Ron,
To suppress the 'Enable Macros' message, several conditios must be met.
1) The user's security level must be at Medium or lower.
2) You need to add a certificate of authenticity to the workbook.
To accomplish #2,
(i) find the selfcert.exe program on your hard drive.
(ii) follow it's directions to create your certification.
(iii) add the certification to the workbook by (a) opening the workbook and
getting in the Visual Basic Editor [Tools > Macro > Visual Basic Editor], (b)
select Tools > Digital Signature and then 'Choose' the certificate you just
created. (c) select OK.
(iv) save the workbook.
3) The first time the user opens the workbook after you have added a
certification, it will ask them if your certification can be trusted. If
they select YES/OK, they will not be asked to enable macros again when
opening that workbook.
To suppress the save changes message when closing the workbook, you need
to add the following code to the ThisWorkbook module...
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
End Sub
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
Ron in Walnut Creek said:
I have a multi-worksheet "Dashboard" that is viewed by numerous people. I
want to prevent changes (protect) and suppress the "Enable Macros" message
(default to YES) when opening the workbook and the "Save Changes" message
(default to NO) when closing the workbook.