Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Naming sheets from a cell value
Hi there,
Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#2
|
|||
|
|||
See
http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#3
|
|||
|
|||
Thanks for the quick response. Stupid question! When does the code get
executed? I tried pressing F9, or do I have to change something? Thanks again "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#4
|
|||
|
|||
If you put it in the worksheet code module, per the instructions, the
macro will fire whenever a cell in the sheet is changed manually. In article , "Tony4X4" wrote: Thanks for the quick response. Stupid question! When does the code get executed? I tried pressing F9, or do I have to change something? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming sheets from a cell value
Hi ..I am really green at this.. could you please help me by starting with
where to creat this macro .. I have tried.. cannot seem to make it happen "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming sheets from a cell value
can we take this abit farther? I'd like then tab names to come up in reverse
order..is there away of doing this? e.g going from left to right December to the left and January to the far right? also if there is a date formula in A1 how do I change the macro as it wants only to read text.. "kathy" wrote: Hi ..I am really green at this.. could you please help me by starting with where to creat this macro .. I have tried.. cannot seem to make it happen "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming sheets from a cell value
this is what I was working from just want the dates to appear on the tabs in
reverse order from what this does.. "Don Guillett" wrote: I don't see the first part of the thread but try sub namesheets() for i=1 to 12 sheets(i).name=sheets(i).range("a1") next end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "kathy" wrote in message ... can we take this abit farther? I'd like then tab names to come up in reverse order..is there away of doing this? e.g going from left to right December to the left and January to the far right? also if there is a date formula in A1 how do I change the macro as it wants only to read text.. "kathy" wrote: Hi ..I am really green at this.. could you please help me by starting with where to creat this macro .. I have tried.. cannot seem to make it happen "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell Reference, Multiple Sheets | Excel Worksheet Functions | |||
Copy cell values across separate sheets | Excel Discussion (Misc queries) | |||
Copying the same cell from different sheets | Excel Discussion (Misc queries) | |||
One cell from several sheets to one column | Excel Discussion (Misc queries) |