| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
not allowing a file to open if macro's are disabled!?
Hi all, I want to be able to stop a workbook being opened if macro's ar diasbled, so i created a workbook with this in the auto_open and the get the workbook to close.....well this works fine.....opens the nex workbook...BUT! it does not initiate the Auto_open on the workbook i opens which kind of defeats the object............. Any solutions welcome! With Application Workbooks.Open ("P:\Public\Shift 1 Activity\Shift1Holidays06.xls") End With Simo -- Simon Lloy ----------------------------------------------------------------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670 View this thread: http://www.excelforum.com/showthread.php?threadid=46740 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| file folder macro's | Links and Linking in Excel | |||
| file folder macro's | Excel Programming | |||
| How to open a spreadsheet with Macros disabled | Excel Discussion (Misc queries) | |||
| In VBA, Open a file with macros disabled | Excel Programming | |||
| Only allowing one open workbook in excel | Excel Programming | |||
![Simon Lloyd[_647_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
