| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro only in active sheet
Hi, How can I program a macro that it only will work in the active worksheet?
Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro only in active sheet
Do you mean only work on a specific sheet?
-- Regards, Tom Ogilvy "jobra" wrote in message ... Hi, How can I program a macro that it only will work in the active worksheet? Thanks in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro only in active sheet
That's exactly what I mean Tom
"Tom Ogilvy" wrote: Do you mean only work on a specific sheet? -- Regards, Tom Ogilvy "jobra" wrote in message ... Hi, How can I program a macro that it only will work in the active worksheet? Thanks in advance |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro only in active sheet
If Ucase(Activesheet.Name) < Ucase("Sheet3") then Exit sub
at the top of the macro might do what you want -- Regards, Tom Ogilvy "jobra" wrote in message ... That's exactly what I mean Tom "Tom Ogilvy" wrote: Do you mean only work on a specific sheet? -- Regards, Tom Ogilvy "jobra" wrote in message ... Hi, How can I program a macro that it only will work in the active worksheet? Thanks in advance |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro only in active sheet
Thanks a lot. This is working just the way I want it.
Thank you very much "Tom Ogilvy" wrote: If Ucase(Activesheet.Name) < Ucase("Sheet3") then Exit sub at the top of the macro might do what you want -- Regards, Tom Ogilvy "jobra" wrote in message ... That's exactly what I mean Tom "Tom Ogilvy" wrote: Do you mean only work on a specific sheet? -- Regards, Tom Ogilvy "jobra" wrote in message ... Hi, How can I program a macro that it only will work in the active worksheet? Thanks in advance |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro only in active sheet
"jobra" wrote in message ... Hi, How can I program a macro that it only will work in the active worksheet? Thanks in advance Sheets("your sheet name").Activate then the rest of your code |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for active sheet only | Excel Discussion (Misc queries) | |||
| diable macro if a certain sheet is active | Excel Discussion (Misc queries) | |||
| emailing active sheet with macro | Excel Worksheet Functions | |||
| macro active sheet | Excel Discussion (Misc queries) | |||
| MACRO for copying active sheet without using a certain name | Excel Programming | |||
Hybrid Mode
