Ed Jarvis
Cisco Systems, Inc.
eja...@cisco.com
Otherwise, there is a programmer who wrote something like this, I'm
unable to locate it but it does exist.
Or, if you are good with design tables and excel, it's possible but not
my forte'.
Let's see, configurations=tables=configurations,.. so why didn't SW have
this working easily since the begining of SW in 1995??? Ah, next
release, SW2004 will, supposedly have this... how many years,... ~7 to
get these two to marry?
..
Lee
"Ed Jarvis" <eja...@cisco.com> wrote in message
news:3E91B441...@cisco.com...
"Ed Jarvis" <eja...@cisco.com> wrote in message
news:3E91B441...@cisco.com...
Anyone else try this?
Paul
"Lee L Bell" <Lee...@Cox.net> wrote in message news:<yrmka.505$J21.228@fed1read06>...
A better probability is that on your system, Excel is set up the way
Microsoft sets it up by default during it's installation. Microsoft
considers EVERY macro in an excel spreadsheet as a virus threat - even the
macros that you create. By default, EVERY macro is simply ignored.
The last two paragraphs in the article did comment on this and did
explain how to avoid this problem, but I should have gone into it in more
detail and made it more obvious. So far, I have had a half dozen people ask
me why it doesn't work the way I said it would.
What you need to do is create a Digital Certificate for your machine.
Running the program C:\Program Files\Microsoft Office\Office\MakeCert.exe
and give it a name. I would use a company name for this rather than a
personal name. If that program is not on your system you will find it on the
CD's. This needs to be done on every machine that will open this
spreadsheet.
After you have a Digital Certificate, start Excel. Before you load the
example file, do a Tools\Macro\Security and in the Security Level tab, set
it to Medium. Now open the example spreadsheet. You will see a nasty warning
that states that the spreadsheet has macros in it that may be harmful to you
system and ask if you want to run them. Answer Yes. Now start the macro
editor (Tools\Macro\Visual Basic Editor).
You will be able to see the macros in question by double clicking the
"This Workbook tab in the project area. They are not much really. The last
thing that you need to do is give this spreadsheet the digital signature
that you just created. Tools\Digital Signature and then Choose. Do a save
and Exit out of the Macro editor.
Switch to the SW Sheets and close the spreadsheet. You can change your
security setting back to High again Tools\Macro\Security and in Security
Level. Then close Excel.
You can see that everything is working properly by restarting Excel and
opening the example spreadsheet. It should flash and then display the
Instructions sheet. When it closes, it is automatically placed in the SW
Sheet.
Now when the spreadsheet is added to the Tabulated.SLDDRW part file
there will be no error message and everything will work properly.
Lee
"Paul Charbonneau" <pa...@amed.com> wrote in message
news:a3267463.03041...@posting.google.com...