| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
error in attempt to warn about macro security
The code doesn't execute until the workbook is opened.
You could try hiding the workbook and saving it (Like personal.xls). In your code, you then set up the workbook the way you want to see it and then make it visible. In the before close event, you would need to hide it again and save it. -- Regards, Tom Ogilvy "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:56bae65e5fc7d@uwe... Hi Jim, The code works fine now, however, on startup i still see the warning screen flashing by. Is there a way to prevent this from happening? I tried Application.Screenupdating = False DoEvents but that did not do the trick... any ideas? Thanks, Pierre Jim Thomlinson wrote: In any workbook there must be at least 1 visible sheet. You are trying to hide all of the sheets which will not work... Hi, [quoted text clipped - 18 lines] any ideas? Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i get excel to warn me that i already used a certain value | Excel Discussion (Misc queries) | |||
| Compile error in hidden module: security | Excel Programming | |||
| need an error msge when I attempt to enter a duplicate value in a | Excel Discussion (Misc queries) | |||
| Warn if already entered | Excel Worksheet Functions | |||
| Macro Security Error No Macro | Excel Programming | |||
Threaded Mode
