Sheet tabs and scroll bars
It would be nice to have the option of eliminating sheet tabs and scroll bars
from new Excel workbook sheets. If this option already exists, I havent found it yet. Thank you ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...ic.excel.setup |
Sheet tabs and scroll bars
Hi Tom,
How to hide scrollbars and sheet tabs on new workbooks. Sounds like you already know how to hide them (tools, options, view), so what you need to do is create a book.xlt workbook as a template with your workbook options changed as desired. If you also want to change defaults for worksheets you would also create a Sheet.xlt workbook as a template with a single sheet changed to your defaults, and for new workbooks you would change each sheet (typically 3) in your book.xlt. Store your templates in your XLStart folder, in the Microsoft Excel folder, or the alternate startup folder. http://www.mvps.org/dmcritchie/excel/templates.htm If you hide the sheet names in all new workbooks what means are you using to see your worksheet tabs and to change between them. The next chapter is on how Harry broke his own fingers to reduce accidentally hitting the wrong keys. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tom Russell" <Tom wrote in message ... It would be nice to have the option of eliminating sheet tabs and scroll bars from new Excel workbook sheets. If this option already exists, I haven't found it yet. Thank you ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...ic.excel.setup |
Sheet tabs and scroll bars
Hi David
Thank you for correctly analyzing what I wanted to do and for offering a solution. Working with templates is something I have not gotten into before so I will try it earlier in the day when the brain cells are more willing to tackle a new project. €śIf you hide the sheet names in all new workbooks what means are you using to see your worksheet tabs and to change between them?€ť I want to hide sheet tabs in workbooks that have only 1 sheet. When there are multiple sheets, I leave them visible on the bottom of the sheet. To add, change name, or delete sheet tabs I right click on them and follow the pop up menu. Perhaps I will try to create multiple templates if that is possible. I am unable to open this link http://www.mvps.org/dmcritchie/excel/templates.htm These links open http://www.mvps.org/dmcritchie/excel/excel.htm http://www.mvps.org/dmcritchie/excel/search.htm Thank you again for your help and for directing me to some very worthwhile reading material. |
Sheet tabs and scroll bars
Hi Tom,
Remove the s on the end it should be http://www.mvps.org/dmcritchie/excel/template.htm Firefox has an option to hide the tabs if there is only one, it is not something that I could stand though Excel might not be as bad with the tabs at the bottom. Rather than setting up templates why not set up a macro like this to turn them on or off. You check the number of tabs and refuse to hide them if the worksheet count is greater than one. You could even use event macros, but all of this is something I would not want for myself. Perhaps your screen resolution is too low. You could reduce the zoom down from 100% though things work best if you keep it at 100%. You can install the following macro (install in your personal.xls) http://www.mvps.org/dmcritchie/excel/getstarted.htm and invoke it from a menu, or on a toolbar button http://www.mvps.org/dmcritchie/excel/toolbarsl.htm Sub Macro23_toggle() With ActiveWindow If .DisplayHorizontalScrollBar = True AND _ worksheet.count 1 then .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = False .DisplayWorkbookTabs = False Else .DisplayHorizontalScrollBar = True .DisplayVerticalScrollBar = True .DisplayWorkbookTabs = True End If End With End Sub --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tom Russell" wrote in message ... Hi David Thank you for correctly analyzing what I wanted to do and for offering a solution. Working with templates is something I have not gotten into before so I will try it earlier in the day when the brain cells are more willing to tackle a new project. "If you hide the sheet names in all new workbooks what means are you using to see your worksheet tabs and to change between them?" I want to hide sheet tabs in workbooks that have only 1 sheet. When there are multiple sheets, I leave them visible on the bottom of the sheet. To add, change name, or delete sheet tabs I right click on them and follow the pop up menu. Perhaps I will try to create multiple templates if that is possible. I am unable to open this link http://www.mvps.org/dmcritchie/excel/templates.htm These links open http://www.mvps.org/dmcritchie/excel/excel.htm http://www.mvps.org/dmcritchie/excel/search.htm Thank you again for your help and for directing me to some very worthwhile reading material. |
Sheet tabs and scroll bars
Thanks again, David. I have not gotten into macros without help from my son
who does everything while dad watches in amazement. And he now lives 2 states away. Therefore I dont have the foggiest idea where to start. But I assume I have to copy what you wrote and past it somewhere, but where is that somewhere? I dont have a file titled €śpersonal.xls€ť that I am aware of. Would you have time to lead me through this? Now I have to go to the kitchen and repair a dishwasher before I get in real trouble. I was able to open the third link without the €śs€ť. |
Sheet tabs and scroll bars
Hi Tom,
See You can install the macro in your personal.xls http://www.mvps.org/dmcritchie/excel/getstarted.htm which has far more information than I would put into a reply. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tom Russell" wrote in message ... Thanks again, David. I have not gotten into macros without help from my son who does everything while dad watches in amazement. And he now lives 2 states away. Therefore I don't have the foggiest idea where to start. But I assume I have to copy what you wrote and past it somewhere, but where is that somewhere? I don't have a file titled "personal.xls" that I am aware of. Would you have time to lead me through this? Now I have to go to the kitchen and repair a dishwasher before I get in real trouble. I was able to open the third link without the "s". |
Sheet tabs and scroll bars
David:
You posted: €śThis thread is an example where Google Groups is not posting the original question when posted through Microsoft CDO (Communities).€ť If you are referring to my posts not having a copy of previous posts, I should mention that I deleted them. Tom "David McRitchie" wrote: This thread is an example where Google Groups is not posting the original question when posted through Microsoft CDO (Communities). http://groups.google.com/groups?thre...GP09.phx .gbl If I ask for the thread through the original post, it is not found in Google http://groups.google.com/groups?thre...0microsoft.com If I ask for the thread through the original post, this way it will be available in this newsgroup for about two months on the Microsoft newsservers. Looks like Google is picking up the groups from another place, or Microsoft is messing up newsgroups when posted through web access. You can see the original posting while still there with news://msnews.microsoft.com/79259CF3...0microsoft.com --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tom Russell" <Tom wrote in message ... It would be nice to have the option of eliminating sheet tabs and scroll bars from new Excel workbook sheets. If this option already exists, I haven't found it yet. Thank you ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...ic.excel.setup |
Sheet tabs and scroll bars
David:
I did copy and paste your suggested macro into a new workbook according to instructions in €śGetting Started with Macros and User Defined Functions€ť but got an error message I cant resolve. Maybe I will have better luck tomorrow. Thanks again for your help. Tom "David McRitchie" wrote: Hi Tom, See You can install the macro in your personal.xls http://www.mvps.org/dmcritchie/excel/getstarted.htm which has far more information than I would put into a reply. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tom Russell" wrote in message ... Thanks again, David. I have not gotten into macros without help from my son who does everything while dad watches in amazement. And he now lives 2 states away. Therefore I don't have the foggiest idea where to start. But I assume I have to copy what you wrote and past it somewhere, but where is that somewhere? I don't have a file titled "personal.xls" that I am aware of. Would you have time to lead me through this? Now I have to go to the kitchen and repair a dishwasher before I get in real trouble. I was able to open the third link without the "s". |
Sheet tabs and scroll bars
Hi Tom,
If you could and did delete a message that would explain things, but you can't delete messages and if you click on the news link or paste it into your browser you will see that it is still there. news://msnews.microsoft.com/79259CF3...0microsoft.com "Tom Russell" wrote in message ... David: You posted: "This thread is an example where Google Groups is not posting the original question when posted through Microsoft CDO (Communities)." If you are referring to my posts not having a copy of previous posts, I should mention that I deleted them. Tom "David McRitchie" wrote: This thread is an example where Google Groups is not posting the original question when posted through Microsoft CDO (Communities). http://groups.google.com/groups?thre...GP09.phx .gbl If I ask for the thread through the original post, it is not found in Google http://groups.google.com/groups?thre...0microsoft.com If I ask for the thread through the original post, this way it will be available in this newsgroup for about two months on the Microsoft newsservers. Looks like Google is picking up the groups from another place, or Microsoft is messing up newsgroups when posted through web access. You can see the original posting while still there with news://msnews.microsoft.com/79259CF3...0microsoft.com --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tom Russell" <Tom wrote in message ... It would be nice to have the option of eliminating sheet tabs and scroll bars from new Excel workbook sheets. If this option already exists, I haven't found it yet. Thank you ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...ic.excel.setup |
Sheet tabs and scroll bars
Hi Tom,
Look at the http://www.mvps.org/dmcritchie/excel...d.htm#problems for some things that could go wrong. You have to set the security to Medium within Excel. If you have a message include the full text letter for letter with punctuation of the error. You can use that within double quotes to search Google Groups or as a Google web search.. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tom Russell" wrote I did copy and paste your suggested macro into a new workbook according to instructions in "Getting Started with Macros and User Defined Functions" but got an error message I can't resolve. Maybe I will have better luck tomorrow. |
Sheet tabs and scroll bars
The above post requires clarification by adding 3 words to the end (in bold
italics) as follows: David: You posted: €śThis thread is an example where Google Groups is not posting the original question when posted through Microsoft CDO (Communities).€ť If you are referring to my posts not having a copy of previous posts, I should mention that I deleted them from my posts. Tom |
Sheet tabs and scroll bars
David
Its beginning to look like I am hopelessly over my head. I have been working on it for over an hour and am not getting anywhere very fast. And my bride is beginning to wonder or perhaps I should say she is continuing to wonder about my sanity or lack of it. I printed everything from your links that applies to setting up macros and plan to work on it again tomorrow. Thanks for your patience and your help. Tom |
All times are GMT +1. The time now is 01:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com