ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Macros Excel 2000 And Excel 2003 (https://www.excelbanter.com/new-users-excel/30737-macros-excel-2000-excel-2003-a.html)

travelersway

Macros Excel 2000 And Excel 2003
 

I've prepared a program using Excel 2000. It has macros. I have the
option to enable the macros when the program opens. I tried to load
this program on Excel 2003, the warning came up and offered a solution
to reduce the security level. Is there a way to enable the macros
without adjusting the security level in Excel 2003?

I attemped to print a worksheet from this wookbook in Excel 2003 and it
added a second page which was blank. Is this an excel change or would it
be related to the printer?

Help appreciated,
Travelersway


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=379130


Alan

First Question,
There is a way to enable macros in 2003 using Digital Signatures, but the
easiest way is to set Security to Medium, you only need to do it once.
Second Question,
If you set the print area and then adjust Page Setup until the print preview
only shows one page, that should do it. I doubt if its your printer at
fault,
Regards,
Alan.
"travelersway"
wrote in message
news:travelersway.1qmu6s_1118779573.3807@excelforu m-nospam.com...

I've prepared a program using Excel 2000. It has macros. I have the
option to enable the macros when the program opens. I tried to load
this program on Excel 2003, the warning came up and offered a solution
to reduce the security level. Is there a way to enable the macros
without adjusting the security level in Excel 2003?

I attemped to print a worksheet from this wookbook in Excel 2003 and it
added a second page which was blank. Is this an excel change or would it
be related to the printer?

Help appreciated,
Travelersway


--
travelersway
------------------------------------------------------------------------
travelersway's Profile:
http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=379130




gls858

travelersway wrote:
I've prepared a program using Excel 2000. It has macros. I have the
option to enable the macros when the program opens. I tried to load
this program on Excel 2003, the warning came up and offered a solution
to reduce the security level. Is there a way to enable the macros
without adjusting the security level in Excel 2003?

I attemped to print a worksheet from this wookbook in Excel 2003 and it
added a second page which was blank. Is this an excel change or would it
be related to the printer?

Help appreciated,
Travelersway


question 2
Check your margins. I find I get this when the margins
aren't set correctly.

gls858

travelersway


Thank you both for your input.
Travelersway


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=379130



All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com