Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work Book Security
No.
You can do various things, such as hide your sheets and unhide them via code (leaving a single splash sheet saying "You must enable macros"). But protection in XL is very weak. It's a matter of a minute or less to remove all internal and VBA protection from a workbook, with the right tools, so you can't force the user to do much of anything... In article , "Brent" wrote: Is there a way to force someone to enable Macro's before opening up an Excel file? I'm currently on Office XP. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work Book Security
Is there a way to force someone to enable Macro's before opening up an Excel
file? I'm currently on Office XP. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work Book Security
Well Brent,
The only way to be sure is to be standing behind the users PC and ensuring that he is enabling macros. Well jokes apart, you can sign your VBA project digitally and install your digital certificate on every users PC. With digitally singed and certificate verified it will not ask user whether to eanble macros or not, the macros will be simply enabled. Sharad *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work Book Security
No. In order for code to run to determine whether macros are enabled,
macros have to be enabled... Note that your current scheme wouldn't prevent anyone from setting the date back on their machine, and opening a copy of the file. In article , "Brent" wrote: Thanks for the info. I have some code written that looks at the date and if it is greater than a value I put in it then it deletes the sheet and saves file. I'm really new at the VB side. Is there some code that looks wether Macro's are Enabled? Again thanks for the help. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work Book Security
Thanks for the info. I have some code written that looks at the date and
if it is greater than a value I put in it then it deletes the sheet and saves file. I'm really new at the VB side. Is there some code that looks wether Macro's are Enabled? Again thanks for the help. Brent "JE McGimpsey" wrote in message ... No. You can do various things, such as hide your sheets and unhide them via code (leaving a single splash sheet saying "You must enable macros"). But protection in XL is very weak. It's a matter of a minute or less to remove all internal and VBA protection from a workbook, with the right tools, so you can't force the user to do much of anything... In article , "Brent" wrote: Is there a way to force someone to enable Macro's before opening up an Excel file? I'm currently on Office XP. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
work book | Excel Worksheet Functions | |||
macros won't work stupid security | Excel Discussion (Misc queries) | |||
Macro won't work due to Security Setting? | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
simultaneously work in a work book with other users | Excel Discussion (Misc queries) |