Hi everyone :-)
I would like to save the worksheet after it is printed. I have the
"saving part" of the code below. I can't figure out how to get it to
execute after the worksheet is printed. I've been researching
different types of Methods (Events), but can't seem to identify any
that will run m
Why not put a command button in that cell? That should do what you want.
Sunil Korah
On Thu, Sep 11, 2008 at 8:38 PM, Tony Bender <[EMAIL PROTECTED]> wrote:
>
> Is there a way to set a cell so when the user clicks on it, it
> launches a specified macro?
>
> If so can you show me how it's done?
>
Place this code in private module of the worksheet:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If ActiveCell.Address = "$C$3" Then
Cancel = True
Call MyMacro
End If
End Sub
As soon as user double clicks the Cell C3, it cancels the click action and
call
Put this code behind the sheet that you are using
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
If Target.Address = "$A$1" Then
RightCellClicked
Else
WrongCellClicked
End If
End Sub
Insert a module in the workbook and put this cod
At the start of the program use the following code
-
Application.screenupdating=false
-
before terminating the program, repeat the above code with 'true' on the
right hand side.
Akhilesh
On Thu, Sep 11, 2008 at 11:45 PM, Lawrence <[EMAIL PROTECTED]> wrote:
>
> Hi
>
> At the moment I am
Hi Tony, try this code:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'Adjust to your range
If Intersect(Target, Range("A2:A25")) Is Nothing Then Exit Sub
MsgBox "macro" 'your code
End Sub
Tony Bender wrote:
> Is there a way to set a cell so when the user clicks
Application.screenupdating = false (at the beggingin of your module)
this will get rid of the flashing, as Excel is trying to update your
GUI throughout the code. Try that first to see if there is noticable
improvement in perfomance time...
As a rule i avoid activate and select in all my excel v
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$B$3" Then MsgBox ("Call your Code here!!")
End Sub
set this in the worksheet object code in VBA
Tril
On Sep 11, 8:08 am, Tony Bender <[EMAIL PROTECTED]> wrote:
> Is there a way to set a cell so when the
Hi Everyone,
Pls find attached Excel Shortcuts.
Regards
hpreddy
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit th
Using "Application.Screenupdating = False " will disable the Screen
flickering. you can enable after the loop.
Also, I using ActiveCell for time consuming tasks. there are alternatives
like With Selection etc.. if you could post more details or the code
snippet, we can suggest more.
On Thu, Sep 11
Hi,
Right-click your sheet tab and select View Code.
Copy and Paste the following into the worksheet window:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)If Not
Intersect(Target, Range("A1")) Is Nothing Then Call macroEnd Sub
Change the range ref to the cell you want to use.
Chang
For a start, you don't need to activate the sheet to do things to it.
You can write for example:
Sheet1.range("a1").offset etc
As for the activecell and offsetting there are better ways but depends
on how your workbook is set up (named ranges are useful here)
If you post your actual code
Is there a way to set a cell so when the user clicks on it, it
launches a specified macro?
If so can you show me how it's done?
Thank you,
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this
Hi
At the moment I am using Activate to switch between sheets and use
ActiveCell and Offset to move between cells, however I also have many
loops...so using this method takes upwards of 10 seconds to execute
and also the screen flickers lots! Is there any more efficient ways of
navigating between
14 matches
Mail list logo
