| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assign Macro with Hidden Sheet
Hi,
I made assign macro in sheet 1 which is linked to sheet 2. Whenever I hide sheet 2, It wont works and says : run-time error '1004' select method of worksheet class failed. Then it will open VBS array with yellow mark status need to be edited or something. How can I solve this problem? Much Appreciate, Pran |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to run on hidden sheet | Excel Discussion (Misc queries) | |||
| Using a Macro to look at Hidden Sheet | Excel Discussion (Misc queries) | |||
| Macro Error When Connecting to Hidden Sheet | Excel Discussion (Misc queries) | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| Can a macro format a hidden sheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
