| Author |
Message |
| Registered: May 19, 2007 | Reputation:  |  Posts: 5,917 |
| | Posted: | | | | Not sure if it's the same with 2007 but with 2003, you select Tools > Macro > Security - and then select Medium security. This will prompt you when you start up a worksheet with macros if you wish to enable them or not. |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 2,005 |
| |
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,394 |
| | Posted: | | | | Quoting Dr. Killpatient Quote:
Not sure if it's the same with 2007 but with 2003, you select Tools > Macro > Security - and then select Medium security. This will prompt you when you start up a worksheet with macros if you wish to enable them or not. Yes, this will work with 2003, but for some reason you don't get the same options with 2007. At least I couldn't find them last night. Quoting TomGains Quote:
And also Matthias has signed the makros and you can tell Excel to always trust this source and will therefore not ask you again in the future. But for some reason it does not work for me (the "always trust this source" checkbox is disabled in my Excel 2002). If I remember correctly, I got some message that there was something about Matthias signature it didn't recognize - so I never got an option to "always trust" him. I'll investigate some more at home with Excell 2007 to come up with the specific message I get when I try to enable the macros in his worksheet. Thanks for the quick responses, guys. | | | Another Ken (not Ken Cole)
Badges? We ain't got no badges. We don't need no badges. I don't have to show you any stinking badges.
DVD Profiler user since June 15, 2001 |
|
| Registered: March 14, 2007 | Reputation:  | | Posts: 1,029 |
| | Posted: | | | | Quoting kdh1949: Quote:
Quoting Dr. Killpatient
Quote:
Not sure if it's the same with 2007 but with 2003, you select Tools > Macro > Security - and then select Medium security. This will prompt you when you start up a worksheet with macros if you wish to enable them or not.
Yes, this will work with 2003, but for some reason you don't get the same options with 2007. At least I couldn't find them last night. Could it be that Excel 2007 doesn't allow you change the level of macro security if you are logged in as a normal user? Unfortunately, I don't have Excel 2007 myself, so I can't give you a more specific answer. detlefs, who did the Excel 2007 compatibility test for me, didn't report any problems activating the macros, and I very much doubt that he had all macros enabled by default. Quoting TomGaines: Quote:
And also Matthias has signed the makros and you can tell Excel to always trust this source and will therefore not ask you again in the future. But for some reason it does not work for me (the "always trust this source" checkbox is disabled in my Excel 2002). That's strange. As a workaround, you could sign the VBA project yourself using your own certificate. If you do that, be sure to Open the file CreditsEditor.xslt (via right-click, Open) and save it afterwards instead of creating a new workbook based on the template (via double-click). | | | | Matthias | | | | Last edited: by goodguy |
|
| Registered: May 19, 2007 | | Reputation: |  Posts: 5,715 |
| | Posted: | | | | Quoting TomGaines: Quote:
And also Matthias has signed the makros and you can tell Excel to always trust this source and will therefore not ask you again in the future. But for some reason it does not work for me (the "always trust this source" checkbox is disabled in my Excel 2002). That's OK! It is a two step process: 1.) Import the certificate (you can't check the checkbox "Alway trust..." this time) 2.) on the next usage of the Sheet, when the certificate - and therefore the source of the macros - is already known, you can check the "Always trust..." check box. Regards, AA BTW: Importing and trusting certificates is far superior to degrading the macro security, since degrading the macro security effects each and every source - included any form of downloaded malware... | | | | Complete list of Common Names • A good point for starting with Headshots (and v11.1) |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,005 |
| |
| Registered: August 22, 2007 | | Reputation: | | Posts: 1,807 |
| | Posted: | | | | Quoting goodguy: Quote:
An Excel workbook template for editing cast and crew credits with maximum flexibility.
Thanks! | | | | -- Enry |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,394 |
| | Posted: | | | | @Matthias, AA & Tom:
Your input all helped. It turned out I had to click on a link that said "Show Signature Details." When I clicked on that link, I got the page that let me accept Matthias' digital signature. So now I am up and running! | | | Another Ken (not Ken Cole)
Badges? We ain't got no badges. We don't need no badges. I don't have to show you any stinking badges.
DVD Profiler user since June 15, 2001 |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 1,029 |
| | Posted: | | | | Quoting ya_shin: Quote:
Not having Excel at home I have to hope that OpenOffice can handle it... Did you have a chance to test it with OpenOffice? As DariusKyrak said in the other thread, Novell's VBA interoperability project for OpenOffice could provide a solution, although I suspect that at least some manual tweaking is required. | | | | Matthias |
|
| Registered: March 13, 2007 | | Reputation: |  Posts: 3,436 |
| | Posted: | | | | Quoting goodguy: Quote:
Quoting ya_shin:
Quote:
Not having Excel at home I have to hope that OpenOffice can handle it...
Did you have a chance to test it with OpenOffice? As DariusKyrak said in the other thread, Novell's VBA interoperability project for OpenOffice could provide a solution, although I suspect that at least some manual tweaking is required. Well I loaded it in OpenOffice just to be reminded that VBA scripts don't really work there...  I must have missed Darius' comment and will have to look into that Novell VBA thing to find out what it can do for me... | | | Achim [諾亞信； Ya-Shin//Nuo], a German in Taiwan.
Registered: May 29, 2000 (at InterVocative) |
|
| Registered: June 12, 2007 | | Reputation: | | Posts: 2,665 |
| | Posted: | | | | Goodguy, if you are taking suggestions for additional features for this fine tool let me toss out a couple.
Macros/buttons that, when pressed, move the current line up or down one line.
Macros/buttons that insert/delete lines.
These are functions i've used and abused in Tom Gaines editor and would like to do the same here.
I can write my own macros to do these (pretty simple Excel functions) but i think they might generally useful.
Thanks for your efforts. | | | | Bad movie? You're soaking in it! |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,005 |
| | Posted: | | | | Quoting tweeter: Quote:
Macros/buttons that, when pressed, move the current line up or down one line. When you do those, I recommend doing it for currently selected lines (i.e. more than one line if more selected) | | | 
 |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 1,029 |
| | Posted: | | | | Quoting tweeter: Quote:
Goodguy, if you are taking suggestions for additional features for this fine tool let me toss out a couple. Your suggestions are all standard operations already available in the Excel user interface. Quote:
Macros/buttons that, when pressed, move the current line up or down one line. Select the rows you want to move around. Point to the thick border surrounding the selection and drag the selection to the target place while holding down the SHIFT key. Quote:
Macros/buttons that insert/delete lines. Insert: Select the desired number of rows below the insertion point, right-click the selection and choose the "Insert Cells" command. Delete: Select the rows you want to delete, right-click the selection and choose the "Delete Cells" command. Note that entire rows can be easily selected by using the row labels on the left side. | | | | Matthias | | | | Last edited: by goodguy |
|
| Registered: June 12, 2007 | | Reputation: | | Posts: 2,665 |
| | Posted: | | | | Quoting goodguy: Quote:
Your suggestions are all standard operations already available in the Excel user interface.
Yes, they are all there, i just find all the mouse clicking and dragging to be tedious (especially if i'm cleaning up a very screwed up credit list). I can and will make my own macros and hook function keys to them and thought the same might be generally useful.  | | | | Bad movie? You're soaking in it! |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 1,029 |
| | Posted: | | | | Quoting tweeter: Quote:
I can and will make my own macros and hook function keys to them... Default shortcut keys for the operations described above:  Shift+Space - Select entire row(s) Ctrl+Hyphen - Delete cell(s) Ctrl+Plus - Insert cell(s) Ctrl+X, goto target place, Ctrl+Plus - Move cell(s) See Excel Help for more. | | | | Matthias |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,005 |
| |