Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro security & digital certificate
I have reviewed the messages on this newsgroups regarding the "High
Security" setting for Macros and in order to prevent the macros from being disabled it is necessary to obtain a digital certificate. I have the following situations & I was not exactly sure how digital certificates would be handled in the situation described below: 1) I have a Excel spreadsheet with many Macros built into it. 2) Since the default security setting in EXCEL is most often "High", the macros are disabled. 3) In order to circumvent this, I plan to buy a digital certificate (Is this the correct approach for the problem?) 4) Users using the Excel file do enter data into it & save it with the new data. The workbook & all worksheets are protected so that they cannot change any macros, just enter data where permitted My question is, if the users save the file, then does the "Digital Certificate" identify that the file has changed, & next time the users open it, will it automatically disable the macros due to the High Security setting. In other words will buying the Digital Certificate serve my purpose or will saving the filll after new data entry will somehow identify the file as changed & cause the same problem that I was trying to solve by getting a digital certificate. Would appreciate your help. TIA Vinay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Security and Digital signatures - PANIC HELP requested | Excel Discussion (Misc queries) | |||
Problem with digital certificate | Excel Discussion (Misc queries) | |||
digital certificate | Excel Programming | |||
Digital Certificate | Excel Programming | |||
Digital Certificate | Excel Programming |