| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box Macro
I've created a spreadsheet with various checkboxes throughout it to replace
an older version. Unfortunately the old version is protected and I don't know the password so I had to start from scratch. Both versions have checkboxes but only the new one gives a Security Warning stating "Macros may contain viruses. It is usually safe to disable macros, but if the macros are legitimate, you might lose some functionality." The spreadsheet is going to be distributed to clients so I can't just change my security settingsget rid of the message. If I leave it there and someone doesn't allow the macro they can't use the checkbox. How do I get the spreadsheet to not give a Security Warning but still keep the checkboxes active? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Box Macro
Look into making your VBA into an add-in.
-- Gary''s Student - gsnu200793 "bjh" wrote: I've created a spreadsheet with various checkboxes throughout it to replace an older version. Unfortunately the old version is protected and I don't know the password so I had to start from scratch. Both versions have checkboxes but only the new one gives a Security Warning stating "Macros may contain viruses. It is usually safe to disable macros, but if the macros are legitimate, you might lose some functionality." The spreadsheet is going to be distributed to clients so I can't just change my security settingsget rid of the message. If I leave it there and someone doesn't allow the macro they can't use the checkbox. How do I get the spreadsheet to not give a Security Warning but still keep the checkboxes active? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Box Macro
I'm new to using VBA how would I go about making it into an add-in?
"Gary''s Student" wrote: Look into making your VBA into an add-in. -- Gary''s Student - gsnu200793 "bjh" wrote: I've created a spreadsheet with various checkboxes throughout it to replace an older version. Unfortunately the old version is protected and I don't know the password so I had to start from scratch. Both versions have checkboxes but only the new one gives a Security Warning stating "Macros may contain viruses. It is usually safe to disable macros, but if the macros are legitimate, you might lose some functionality." The spreadsheet is going to be distributed to clients so I can't just change my security settingsget rid of the message. If I leave it there and someone doesn't allow the macro they can't use the checkbox. How do I get the spreadsheet to not give a Security Warning but still keep the checkboxes active? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Box Macro
FileSave AsFile Type MS Excel Add-in(*.xla)
Way down at the bottom of the dialog box. Gord On Tue, 24 Jun 2008 12:47:00 -0700, bjh wrote: I'm new to using VBA how would I go about making it into an add-in? "Gary''s Student" wrote: Look into making your VBA into an add-in. -- Gary''s Student - gsnu200793 "bjh" wrote: I've created a spreadsheet with various checkboxes throughout it to replace an older version. Unfortunately the old version is protected and I don't know the password so I had to start from scratch. Both versions have checkboxes but only the new one gives a Security Warning stating "Macros may contain viruses. It is usually safe to disable macros, but if the macros are legitimate, you might lose some functionality." The spreadsheet is going to be distributed to clients so I can't just change my security settingsget rid of the message. If I leave it there and someone doesn't allow the macro they can't use the checkbox. How do I get the spreadsheet to not give a Security Warning but still keep the checkboxes active? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Box Macro
My guess would be to protect the sheet and save as "macro enabled workbook"
in the file type dropdown when saving. I don't know 100% but you can try. "bjh" wrote: I've created a spreadsheet with various checkboxes throughout it to replace an older version. Unfortunately the old version is protected and I don't know the password so I had to start from scratch. Both versions have checkboxes but only the new one gives a Security Warning stating "Macros may contain viruses. It is usually safe to disable macros, but if the macros are legitimate, you might lose some functionality." The spreadsheet is going to be distributed to clients so I can't just change my security settingsget rid of the message. If I leave it there and someone doesn't allow the macro they can't use the checkbox. How do I get the spreadsheet to not give a Security Warning but still keep the checkboxes active? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Box Macro
Purchase a Digital Certificate from one of the purveyors of DC's like Thawte or
Verisign Help gives you more details about signing a workbook under "about digital signatures" Gord Dibben MS Excel MVP On Tue, 24 Jun 2008 12:16:03 -0700, bjh wrote: I've created a spreadsheet with various checkboxes throughout it to replace an older version. Unfortunately the old version is protected and I don't know the password so I had to start from scratch. Both versions have checkboxes but only the new one gives a Security Warning stating "Macros may contain viruses. It is usually safe to disable macros, but if the macros are legitimate, you might lose some functionality." The spreadsheet is going to be distributed to clients so I can't just change my security settingsget rid of the message. If I leave it there and someone doesn't allow the macro they can't use the checkbox. How do I get the spreadsheet to not give a Security Warning but still keep the checkboxes active? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Customized Macro Button Check | Excel Discussion (Misc queries) | |||
| To be safe - how to check macro before run it? | Excel Discussion (Misc queries) | |||
| need macro to check part# and sum | Excel Worksheet Functions | |||
| how do i create a macro for putting a check in a box? | Excel Worksheet Functions | |||
| How do I link a check box to a macro? | Excel Worksheet Functions | |||
Hybrid Mode
