Macros/Signatures Question

C

Curt

I have an Excel Workbook that I created for a PC Order Form. I set it up to
only make certain rows visible based on the Machine Model that they choose.
I digital signed the Worksheets and exported the Digital Signature
Certificate and installed it on the User’s PCs. The code works great. The
user opens the Workbook and it runs the Macros with no problem. The problem
I have is when the user goes to save the Workbook. They get an error that
“Excel can not sign VBA macros when saving to this file format. Do you want
to remove the digital signature and continue saving this workbook?†Then the
next time they open the Workbook the Macros do not work since we have Macro
Security set to high. Is it possible to sign a Workbook and have it keep the
signature after a save is performed? I do not want to have to change the
User’s Macro Security Settings if possible.

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range

If Range("B3").Value > 0 Then
For Each c In Range("A7:A40")
If c.Value = 8 Then
Rows(c.Row).Hidden = False
End If
Next c
Else
For Each c In Range("A7:A40")
If c.Value = 8 Then
Rows(c.Row).Hidden = True
End If
Next c
End If

If Range("B4").Value > 0 Then
For Each c In Range("A7:A40")
If c.Value = 5 Then
Rows(c.Row).Hidden = False
End If
Next c
Else
For Each c In Range("A7:A40")
If c.Value = 5 Then
Rows(c.Row).Hidden = True
End If
Next c
End If
End Sub
 
N

nuver

Hello
Try to save the file as a Microsoft workbook format as opposed to a
Microsoft specific version number. When you save the workbook use save
as and scroll to the first selection under save file type as, this
should be the Microsoft workbook format which is for Excel 97-2000
versions. Hope this solves your problem
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top