macro virus protection

L

LiSa

Is there any way of not allowing a workbook to be opened
if the macros are disabled?
 
T

Tom Ogilvy

No, that is a user's choice. You can hide worksheets and have your code
unhide them - so if it is opened with macros disabled there won't be much
usability. This will encourage users to enable macros.
 
J

Jim Rech

No there isn't. About the best you can do is have your workbook in such a
state that it cannot be used with macros disabled, such as having key sheets
hidden.

--
Jim Rech
Excel MVP
| Is there any way of not allowing a workbook to be opened
| if the macros are disabled?
|
|
 
B

Bob Flanagan

Create an add-in that has all of your macros in it. This is just a workbook
with the workbook add-in property set to true. The user then only has two
choices: no open or enable macros. Also, it makes it easy to issue new
macros without having to issue a new workbook.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Top