Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Auto Run Problem
Hi,
I created the macro, also got it run automatically whenever we open a workbook. Now, the problem is that this data is linked to charts (Pareto Charts that need to be sorted) and the sheets that contain this data are hidden. The macro is working fine if the sheets are not hidden and if i hide them it gives me an error :( Help Please.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Auto Run Problem
Hi Gary
Can you unhide the sheets during the running of the macro and then rehide them after the task is completed. Try putting Sheets(1).Visible = False Sheets(1).Visible = True If you don't want any user possibly seeing the sheets during the operation Also include Application.screenupdating=False at the beginning of the code and Application.screenupdating=True at the end HTH Michael M in your code "Gary" wrote: Hi, I created the macro, also got it run automatically whenever we open a workbook. Now, the problem is that this data is linked to charts (Pareto Charts that need to be sorted) and the sheets that contain this data are hidden. The macro is working fine if the sheets are not hidden and if i hide them it gives me an error :( Help Please.. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Auto Run Problem
Hi Gary and Michael
Sorry im interupting ur question, but i got a problem I simply cant start a new question I try click on New and select question, but nothin happens can any of u help me out please sry my french im from Denmark :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with auto macro on closing | Excel Discussion (Misc queries) | |||
Problem in macro | Excel Discussion (Misc queries) | |||
problem with macro on Excel | Excel Worksheet Functions | |||
Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
Problem executing a macro from different workbook where it is | Excel Discussion (Misc queries) |