Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Certificate gets removed from shared workbook
At the company I work, we have a spreadsheet that has a number of
worksheets, with contact information and passwords. The spreadsheet is shared in the network, so if someone needs to change a password can change it, and everybody can have access to it. The problem became, when one of the supervisor, wanted the spreadsheet to open to the first page (workbook), because that is the most used one. So I created a macro that will open the excel file always on the first page. I also created a certificate, so we will not get the macro warning every time we open the file and we can keep the security to medium. But now the certificate gets removed by other users (when they make changes, I think), and until I go in and read the certificate on, everyone get the macro warning. My question is if you know a way for the certificate not to get removed, or if it is another way we can set up the excel file to open on the first sheet without using a macro. Thank you, Oana |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Certificate gets removed from shared workbook
Try activating sheet1 in the BeforeClose event
"Oana" wrote: At the company I work, we have a spreadsheet that has a number of worksheets, with contact information and passwords. The spreadsheet is shared in the network, so if someone needs to change a password can change it, and everybody can have access to it. The problem became, when one of the supervisor, wanted the spreadsheet to open to the first page (workbook), because that is the most used one. So I created a macro that will open the excel file always on the first page. I also created a certificate, so we will not get the macro warning every time we open the file and we can keep the security to medium. But now the certificate gets removed by other users (when they make changes, I think), and until I go in and read the certificate on, everyone get the macro warning. My question is if you know a way for the certificate not to get removed, or if it is another way we can set up the excel file to open on the first sheet without using a macro. Thank you, Oana |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Certificate gets removed from shared workbook
If someone else changes the code, the certificate will be removed. That's
the way it is. They get notified that it's happening when they close the workbook, so they probably know they've done it. "Oana" wrote: At the company I work, we have a spreadsheet that has a number of worksheets, with contact information and passwords. The spreadsheet is shared in the network, so if someone needs to change a password can change it, and everybody can have access to it. The problem became, when one of the supervisor, wanted the spreadsheet to open to the first page (workbook), because that is the most used one. So I created a macro that will open the excel file always on the first page. I also created a certificate, so we will not get the macro warning every time we open the file and we can keep the security to medium. But now the certificate gets removed by other users (when they make changes, I think), and until I go in and read the certificate on, everyone get the macro warning. My question is if you know a way for the certificate not to get removed, or if it is another way we can set up the excel file to open on the first sheet without using a macro. Thank you, Oana |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shared workbook - shared workbook options grayed out | Excel Discussion (Misc queries) | |||
How do I email a workbook without macros getting removed? | Excel Discussion (Misc queries) | |||
Shared Workbook - Slow opening of shared workbook. | Excel Programming | |||
Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
digital certificate being discarded from a shared workbook | Excel Programming |