Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using xlsm worksheets on different computers
So I just creaed the greatest spreadsheet ever with lots of Visual Basic and
Macro buttons that makes it a dream for the user to use. A startup macro opens at the Menu page, lots of hyperlinks to various worksheets, lots of macro buttons, tabs hidden, VB password protected, hidden worksheets, an expiry date on the workbook which inhibits further use after a certain date etc.... You get the idea. I digitally signed it and installed it on the computer where it will be used. At the end of each week this monthly file is emailed to a number of managers, and I soon realised the fruits of my work are useless. The Macro Security just put a stop on everything I designed. This means that I would have to digitally sign each email copy onto the computer of each manager. Also, at the end of each month, the file is copied, cleared of data and the new month set up which then compounds the problem with a new file each month. What can I do to get my workbook to work as designed? What is the point of Excel having all these great functions if it won't work on the next computer??? Thanks Frustrated Ant |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using xlsm worksheets on different computers
I believe each manager just needs to save the signature tied to that workbook
to their machine. That can be done when they enable the macros. Once that's done, they'll need to trust the publisher. They'll not have to enable a macro from you again. -- HTH, Barb Reinhardt "Ant" wrote: So I just creaed the greatest spreadsheet ever with lots of Visual Basic and Macro buttons that makes it a dream for the user to use. A startup macro opens at the Menu page, lots of hyperlinks to various worksheets, lots of macro buttons, tabs hidden, VB password protected, hidden worksheets, an expiry date on the workbook which inhibits further use after a certain date etc.... You get the idea. I digitally signed it and installed it on the computer where it will be used. At the end of each week this monthly file is emailed to a number of managers, and I soon realised the fruits of my work are useless. The Macro Security just put a stop on everything I designed. This means that I would have to digitally sign each email copy onto the computer of each manager. Also, at the end of each month, the file is copied, cleared of data and the new month set up which then compounds the problem with a new file each month. What can I do to get my workbook to work as designed? What is the point of Excel having all these great functions if it won't work on the next computer??? Thanks Frustrated Ant |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using xlsm worksheets on different computers
Hi Barb,
Thanks for the help. I created the spreadsheet on my home computer. When I emailed it to my work computer, there was no option to enable my home Digital Signature on the work computer. I had to create and install a new digital signature on the work computer. Could you point me in the right direction as I could see no option to allow that. Ant "Barb Reinhardt" wrote: I believe each manager just needs to save the signature tied to that workbook to their machine. That can be done when they enable the macros. Once that's done, they'll need to trust the publisher. They'll not have to enable a macro from you again. -- HTH, Barb Reinhardt "Ant" wrote: So I just creaed the greatest spreadsheet ever with lots of Visual Basic and Macro buttons that makes it a dream for the user to use. A startup macro opens at the Menu page, lots of hyperlinks to various worksheets, lots of macro buttons, tabs hidden, VB password protected, hidden worksheets, an expiry date on the workbook which inhibits further use after a certain date etc.... You get the idea. I digitally signed it and installed it on the computer where it will be used. At the end of each week this monthly file is emailed to a number of managers, and I soon realised the fruits of my work are useless. The Macro Security just put a stop on everything I designed. This means that I would have to digitally sign each email copy onto the computer of each manager. Also, at the end of each month, the file is copied, cleared of data and the new month set up which then compounds the problem with a new file each month. What can I do to get my workbook to work as designed? What is the point of Excel having all these great functions if it won't work on the next computer??? Thanks Frustrated Ant |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using xlsm worksheets on different computers
Where did you get the Digital Signature?
You mention "create and install". If you created it using the Office SelfCert tool you cannot export that key to another computer. If the users simply move your workbook into a Trusted Location on their computer a DS is not required. Gord On Mon, 12 Apr 2010 19:12:01 -0700, Ant wrote: Hi Barb, Thanks for the help. I created the spreadsheet on my home computer. When I emailed it to my work computer, there was no option to enable my home Digital Signature on the work computer. I had to create and install a new digital signature on the work computer. Could you point me in the right direction as I could see no option to allow that. Ant "Barb Reinhardt" wrote: I believe each manager just needs to save the signature tied to that workbook to their machine. That can be done when they enable the macros. Once that's done, they'll need to trust the publisher. They'll not have to enable a macro from you again. -- HTH, Barb Reinhardt "Ant" wrote: So I just creaed the greatest spreadsheet ever with lots of Visual Basic and Macro buttons that makes it a dream for the user to use. A startup macro opens at the Menu page, lots of hyperlinks to various worksheets, lots of macro buttons, tabs hidden, VB password protected, hidden worksheets, an expiry date on the workbook which inhibits further use after a certain date etc.... You get the idea. I digitally signed it and installed it on the computer where it will be used. At the end of each week this monthly file is emailed to a number of managers, and I soon realised the fruits of my work are useless. The Macro Security just put a stop on everything I designed. This means that I would have to digitally sign each email copy onto the computer of each manager. Also, at the end of each month, the file is copied, cleared of data and the new month set up which then compounds the problem with a new file each month. What can I do to get my workbook to work as designed? What is the point of Excel having all these great functions if it won't work on the next computer??? Thanks Frustrated Ant |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using xlsm worksheets on different computers
Hi Gord,
Yes, I created the Digital Signature using "Digital Certificates for VBA Projects" under Microsoft Office 2007 Tools which, I assume, is the Office SelfCert tool you referred to. Hmmm.... Trusted Location. I haven't come across that before. Hopefully there should be a few threads relating to it in the Excel Programming Discussions Regards Ant "Gord Dibben" wrote: Where did you get the Digital Signature? You mention "create and install". If you created it using the Office SelfCert tool you cannot export that key to another computer. If the users simply move your workbook into a Trusted Location on their computer a DS is not required. Gord On Mon, 12 Apr 2010 19:12:01 -0700, Ant wrote: Hi Barb, Thanks for the help. I created the spreadsheet on my home computer. When I emailed it to my work computer, there was no option to enable my home Digital Signature on the work computer. I had to create and install a new digital signature on the work computer. Could you point me in the right direction as I could see no option to allow that. Ant "Barb Reinhardt" wrote: I believe each manager just needs to save the signature tied to that workbook to their machine. That can be done when they enable the macros. Once that's done, they'll need to trust the publisher. They'll not have to enable a macro from you again. -- HTH, Barb Reinhardt "Ant" wrote: So I just creaed the greatest spreadsheet ever with lots of Visual Basic and Macro buttons that makes it a dream for the user to use. A startup macro opens at the Menu page, lots of hyperlinks to various worksheets, lots of macro buttons, tabs hidden, VB password protected, hidden worksheets, an expiry date on the workbook which inhibits further use after a certain date etc.... You get the idea. I digitally signed it and installed it on the computer where it will be used. At the end of each week this monthly file is emailed to a number of managers, and I soon realised the fruits of my work are useless. The Macro Security just put a stop on everything I designed. This means that I would have to digitally sign each email copy onto the computer of each manager. Also, at the end of each month, the file is copied, cleared of data and the new month set up which then compounds the problem with a new file each month. What can I do to get my workbook to work as designed? What is the point of Excel having all these great functions if it won't work on the next computer??? Thanks Frustrated Ant . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using xlsm worksheets on different computers
ButtonExcel OptionsTrust CenterTrust Center SettingsTrusted Locations.
Tell users to store your workbook in a Trusted Folder. Gord On Tue, 13 Apr 2010 17:19:01 -0700, Ant wrote: Hi Gord, Yes, I created the Digital Signature using "Digital Certificates for VBA Projects" under Microsoft Office 2007 Tools which, I assume, is the Office SelfCert tool you referred to. Hmmm.... Trusted Location. I haven't come across that before. Hopefully there should be a few threads relating to it in the Excel Programming Discussions Regards Ant "Gord Dibben" wrote: Where did you get the Digital Signature? You mention "create and install". If you created it using the Office SelfCert tool you cannot export that key to another computer. If the users simply move your workbook into a Trusted Location on their computer a DS is not required. Gord On Mon, 12 Apr 2010 19:12:01 -0700, Ant wrote: Hi Barb, Thanks for the help. I created the spreadsheet on my home computer. When I emailed it to my work computer, there was no option to enable my home Digital Signature on the work computer. I had to create and install a new digital signature on the work computer. Could you point me in the right direction as I could see no option to allow that. Ant "Barb Reinhardt" wrote: I believe each manager just needs to save the signature tied to that workbook to their machine. That can be done when they enable the macros. Once that's done, they'll need to trust the publisher. They'll not have to enable a macro from you again. -- HTH, Barb Reinhardt "Ant" wrote: So I just creaed the greatest spreadsheet ever with lots of Visual Basic and Macro buttons that makes it a dream for the user to use. A startup macro opens at the Menu page, lots of hyperlinks to various worksheets, lots of macro buttons, tabs hidden, VB password protected, hidden worksheets, an expiry date on the workbook which inhibits further use after a certain date etc.... You get the idea. I digitally signed it and installed it on the computer where it will be used. At the end of each week this monthly file is emailed to a number of managers, and I soon realised the fruits of my work are useless. The Macro Security just put a stop on everything I designed. This means that I would have to digitally sign each email copy onto the computer of each manager. Also, at the end of each month, the file is copied, cleared of data and the new month set up which then compounds the problem with a new file each month. What can I do to get my workbook to work as designed? What is the point of Excel having all these great functions if it won't work on the next computer??? Thanks Frustrated Ant . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking XLSM to XLS | Setting up and Configuration of Excel | |||
Personal.xlsm | Excel Discussion (Misc queries) | |||
What does the extension '.xlsm' mean | Excel Discussion (Misc queries) | |||
xlsm | Excel Programming | |||
Why does copy after worksheets command not work on some computers | Excel Programming |