Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet tab names change automatically
Hello,
I'm working with Excel 2007. I have a workbook with different sheets and charts, with sheet tab names I all renamed. I created a sort of dashboard (on a sheet) with my most important charts. I recorded macro's and assigned them to buttons (drawings) on my sheets. These macro's are showing other sheets (charts) in the same workbook. My problem is: sometimes on opening my workbook all the charts (sheet tab names) are renamed automatically (ex chart40), every time a higher number, and my macro's don't work any more. I have to change the worksheet names in my macro's. How can I stop excel automatically renaming my worksheets? Thanks for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet tab names change automatically
There might be something in your code which is doing this... Pl. share the
code for any one chart... "MD" wrote: Hello, I'm working with Excel 2007. I have a workbook with different sheets and charts, with sheet tab names I all renamed. I created a sort of dashboard (on a sheet) with my most important charts. I recorded macro's and assigned them to buttons (drawings) on my sheets. These macro's are showing other sheets (charts) in the same workbook. My problem is: sometimes on opening my workbook all the charts (sheet tab names) are renamed automatically (ex chart40), every time a higher number, and my macro's don't work any more. I have to change the worksheet names in my macro's. How can I stop excel automatically renaming my worksheets? Thanks for your help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet tab names change automatically
Hi Sheeloo,
Please find some macro codes, they are similar as these examples (I have more or less 30 macro's) Sub Dash1_vitale_info() ' ' Dash1_vitale_info Macro ' Macro recorded 31/08/2008 by MD ' ' ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 Sheets("Vitale info").Select End Sub Sub Dash1_Grafiek_kostensimulatie() ' ' Dash1_Grafiek_kostensimulatie Macro ' Macro recorded 1/09/2008 by MD ' ' ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 Sheets("Grafiek kostensimulatie").Select End Sub Sub Dash1_abdominale() ' ' Dash1_abdominale Macro ' Macro recorded 2/09/2008 by MD ' ' ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 Sheets("Abdominale").Select End Sub Sub Dash1_natens_cons() ' ' Dash1_natens_cons Macro ' Macro recorded 8/09/2008 by MD ' ' ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 Sheets("Chir cons detail").Select Range("I16").Select Selection.Copy ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 Sheets("Orthopedie").Select Range("I17").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub Sub Dash1_grafiek_orth_cons_ok() ' ' Dash1_grafiek_orth_cons_ok Macro ' Macro recorded 9/09/2008 by MD ' ' ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 Sheets("Grafiek ortho cons OK").Select End Sub Sub Dash1_vergelijking_ortho_cons() ' ' Dash1_vergelijking_ortho_cons Macro ' Macro recorded 15/09/2008 by MD ' ' ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 ActiveWindow.ScrollWorkbookTabs Sheets:=-1 Sheets("Vergelijking Ortho cons").Select End Sub Thanks for your help "Sheeloo" wrote: There might be something in your code which is doing this... Pl. share the code for any one chart... "MD wrote: Hello, I'm working with Excel 2007. I have a workbook with different sheets and charts, with sheet tab names I all renamed. I created a sort of dashboard (on a sheet) with my most important charts. I recorded macro's and assigned them to buttons (drawings) on my sheets. These macro's are showing other sheets (charts) in the same workbook. My problem is: sometimes on opening my workbook all the charts (sheet tab names) are renamed automatically (ex chart40), every time a higher number, and my macro's don't work any more. I have to change the worksheet names in my macro's. How can I stop excel automatically renaming my worksheets? Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change sheet names for charts on the fly | Excel Discussion (Misc queries) | |||
How to change sheet names via formula | Excel Discussion (Misc queries) | |||
Automatically change sequential worksheet names in formulas | Excel Worksheet Functions | |||
Add Names of First Sheet and Automatically Add to Second Sheet | Excel Discussion (Misc queries) | |||
Automatically update links when server names change | Excel Worksheet Functions |