Check Box Macro

[bjh]

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?

 

[Gary''s Student]

Look into making your VBA into an add-in.

 

[mike]

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.

 

[Gord Dibben]

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

 

[bjh]

I'm new to using VBA how would I go about making it into an add-in?

 

[Gord Dibben]

File>Save As>File Type MS Excel Add-in(*.xla)

Way down at the bottom of the dialog box.


Gord