Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
formula question | Excel Worksheet Functions | |||
Page Break View - not the usual question | Excel Discussion (Misc queries) | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |