Dear All,
Kindly any one can help me.
I have attached excel workbook.
sheet2 is having command button. I need to paste command button in all the sheet. Whether i need to paste the command button manually or any other procedure is available?
Once i open the excel workbook, it sould open in full screen view and headlings, gridline and formula bar need not show.
Regards
Suresh G
Your question again is not clear
You've also already asked about the gridlines, etc.
Last edited by royUK; 03-07-2012 at 03:16 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Try this. It's MACRO. Save it as a Macro enabled workbook.
You don't need code to do this. Use hyperlinks
Hi Suresh, as advised by Russell you can use this coding
Sheets("Sheet2").Select
In the above bracket you can give your corresponding sheet name..
Dear Russell Dawson,
Thank you to go to next sheet it is working fine.
I am having more than 50 sheets. Do i require to paste the "Home" command button manually one by one sheet or i can paste at one stretch.
For hiding gridline and heading please suggest me code. To do manually it is very difficult, because I am having more than 50 sheets.
Last edited by SURESH G; 03-07-2012 at 04:13 AM. Reason: spell error
Suresh
As royUK suggests, it may be useful to create hyperlinks especially as you say that you have over 50 sheets. It'll be much quicker when building Sheet 1. Either way you will need to copy and paste the button or the link to the other pages.
Gridlines can be got rid of very quickly, but you will have to go to each sheet and you will be there anyway.. On the view tab on each sheet there is a "Show/Hide" box. Simply uncheck as needed.
Russell
Updated attachment contains sample hyperlinks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks