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

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

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