| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro only in certain file/worksheet
Hi,
I want to make sure that a macro only runs in one certain file. I was thinking to get check the file name of the open file and run the program only if it's the right file. Is there an easier way to do that? If not, how do I get the file name of the open and active worksheet? thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
run macro only in certain file/worksheet
Activesheet.name returns the sheet name, activeworkbook.name the file
"huepf" wrote: Hi, I want to make sure that a macro only runs in one certain file. I was thinking to get check the file name of the open file and run the program only if it's the right file. Is there an easier way to do that? If not, how do I get the file name of the open and active worksheet? thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rename Worksheet Tab as File Name Using a Macro | Excel Discussion (Misc queries) | |||
| Enabling Macro with the worksheet file | Excel Discussion (Misc queries) | |||
| Macro Save with Worksheet as file Name | Excel Programming | |||
| Copying worksheet to new file by macro | Excel Programming | |||
| using macro to save worksheet with unique file name | Excel Programming | |||
Hybrid Mode
