Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
md md is offline
external usenet poster
 
Posts: 23
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 793
Default 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   Report Post  
Posted to microsoft.public.excel.misc
md md is offline
external usenet poster
 
Posts: 23
Default 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
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
Change sheet names for charts on the fly Arlen Excel Discussion (Misc queries) 2 July 30th 08 11:46 AM
How to change sheet names via formula Arlen Excel Discussion (Misc queries) 3 July 28th 08 06:57 PM
Automatically change sequential worksheet names in formulas Magnum Excel Worksheet Functions 3 February 11th 08 11:33 PM
Add Names of First Sheet and Automatically Add to Second Sheet Jorge Excel Discussion (Misc queries) 1 October 12th 06 10:48 PM
Automatically update links when server names change J Hotch Excel Worksheet Functions 1 August 3rd 05 03:50 PM


All times are GMT +1. The time now is 09:51 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"