Macros/Signatures Question
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 Users 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 Users 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 -- Thanks |
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 -- nuver ------------------------------------------------------------------------ nuver's Profile: http://www.excelforum.com/member.php...o&userid=10036 View this thread: http://www.excelforum.com/showthread...hreadid=376424 |
All times are GMT +1. The time now is 02:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com