 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Excel Errors / May 2008Excel 2003 macros not available in Excel 2007?
My new Excel 2007 accepts old Excel 2003 files but there is two problems: 1) I can't use 2003 VBA macros at all when having translated to new file version. I put every where in the settings that please accept all macros etc. but it didn't help. I can't use macros made earlier. 2) I could use macros in Office97/2003 mode but then Conditional formatting was impossible. The size of the file was ten times bigger when the program started to generate new rules all the time. Finally the whole program stopped working. So I had to use new 2007 file version and make those conditional formatting rules again. But then I have that macro problem (see problem number 1). Do I have to rewrite all my macros too? Does anyone know a solution? Hi Mr, > 1) I can't use 2003 VBA macros at all when having translated to new file > version. I put every where in the settings that please accept all macros etc. > but it didn't help. I can't use macros made earlier. Macros do not work with xlsm files that have a file open password. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com Hi Jan Thanks a lot. I removed the file open password and all macros work fine! But is there any reason for that kind of functionality or restriction? My file is very confidential but I really need those macros too in order to be more efficient. Do I have to take password away and put back every time I want to use my macros? Unbelievable if so! Mr Web --- > Hi Mr, > [quoted text clipped - 12 lines] > Professional Office Developer Association > www.proofficedev.com Hi Mr, > Thanks a lot. I removed the file open password and all macros work fine! But > is there any reason for that kind of functionality or restriction? My file is > very confidential but I really need those macros too in order to be more > efficient. Do I have to take password away and put back every time I want to > use my macros? Unbelievable if so! I agree this is a royal PITA and have already submitted a bug report to MSFT about this. In fact it renders protected Excel files with VBA useless as far as I'm concerned. As a side note, I rely on just Excel's protection if I need to keep confidential data if I were you, rather make sure you arrange access to the workbook using other means, such as access rights to the (possibly encrypted) folder where it is saved. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com Hi Jan, > I rely on just Excel's protection if I need to keep confidential > data if I were you Duh, I meant to say: I *would not* rely on just Excel's protection if I need to keep confidential data if I were you Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.