LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 618
Default Macro for Custom view

Hi

yes, i use the drawing toolbar to do this but you can use the button from
the control toolbar too ... whichever way, put the button on the sheet (if
you're using one from the drawing toolbar you can right mouse click on it to
add text) ... once you've placed the button where you want it, right mouse
click on it and choose assign macro - a list of all your macros will be
displayed, just choose the appropriate one and repeat for all :)

Cheers
JulieD


"sushantbapna " wrote in
message ...
Thanks a lot Julie, that works, one more thing - is there a way to get
buttons on the sheet instead of the toolbar?

Thanks
Sushant


---
Message posted from http://www.ExcelForum.com/



 
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
Custom Macro View/Print Toolbar for Calendar KC guru Excel Discussion (Misc queries) 0 February 21st 07 03:30 PM
View Custom View with Sheet Protection John H[_2_] New Users to Excel 1 February 16th 07 05:54 PM
How to view a custom view when the worksheet is protected? JulesJam Excel Worksheet Functions 0 March 6th 06 02:15 PM
Missing "Custom View" entry from View menu mycroft777 Excel Discussion (Misc queries) 1 February 3rd 06 05:33 PM
How do I write a macro for a button to send user to a custom view? Hugnuffer Excel Discussion (Misc queries) 1 August 16th 05 06:34 PM


All times are GMT +1. The time now is 06:33 AM.

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

About Us

"It's about Microsoft Excel"