#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default Excel 2007

I write macros to make it quicker for users to complete a series of steps.
For example, CTRL+SHIFT+Z prints a page on one sheet of the workbook, takes
you to another sheet in the workbook, and highlights the portion of that
sheet you need to print. Then you have to manually change printers to a
label printer, then CTRL+SHIFT+X prints the label and sends you to another
screen.

They work fine when I set them up, and work fine for some users of the
workbook, but for others, an error window pops up and they have to click
"continue" to get the macro to finish running.

???
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default Excel 2007

Hi,

At the very least we would need to see the code and have you tell us when in
the execution the problem is happening.


--
Thanks,
Shane Devenshire


"Gator Girl" wrote:

I write macros to make it quicker for users to complete a series of steps.
For example, CTRL+SHIFT+Z prints a page on one sheet of the workbook, takes
you to another sheet in the workbook, and highlights the portion of that
sheet you need to print. Then you have to manually change printers to a
label printer, then CTRL+SHIFT+X prints the label and sends you to another
screen.

They work fine when I set them up, and work fine for some users of the
workbook, but for others, an error window pops up and they have to click
"continue" to get the macro to finish running.

???

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting a chart from Excel 2007 to Word 2007 trouble Vegas Charts and Charting in Excel 5 September 16th 08 07:37 AM
Import an MS Money 2007 file into MS Excel 2007 worksheet DonF Excel Discussion (Misc queries) 0 August 29th 08 11:14 PM
Excel 2007 Macro Help (Excel 2003 not working in 2007) Pman Excel Discussion (Misc queries) 4 May 29th 08 06:29 PM
Paste EXCEL 2007 sheet into WORD 2007 - objects move around Martin L Excel Discussion (Misc queries) 5 February 29th 08 01:45 PM
Chart Selection - Excel 2007 copy to Powerpoint 2007 GS80 Charts and Charting in Excel 1 February 7th 08 01:30 PM


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"