| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unabling Automatically Macros at opening ?
very smart !!
Thanks, I will use it YB "DNF Karran " wrote in message ... The user gets control over turning on macros and the code cannot directly change this- it is a security measure to stop viruses. All you can do is hide all sheets except for a front sheet which says "You must enable macros to use this workbook". The structure of the workbook is then protected so users cannot get at the data. You then have macros triggered by the workbook open event that unhide the hidden sheets so the spreadsheet can only be used with macros enabled. Duncan --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restricting rights to save a spreadsheet | Excel Worksheet Functions | |||
| is it possible to disable the ability to save a file unless the u. | Excel Discussion (Misc queries) | |||
| Restricting a Spreadsheet so users cannot save changes | Excel Worksheet Functions | |||
| provide ability to undo a save - saved by mistake | Excel Worksheet Functions | |||
| Time restricting a file | Excel Discussion (Misc queries) | |||
Threaded Mode
