| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graps in macros
I'm trying to create a new graph BUT later i need to make some enhancements in it. I'm trying to give the graph a NAME because I need to refere it in another macro, but I can't give a graph a name inn order to later select it. VB uses "GRAPH nn" as a standard name of graphs... Any suggestions??? -- jormonal ------------------------------------------------------------------------ jormonal's Profile: http://www.excelforum.com/member.php...o&userid=34949 View this thread: http://www.excelforum.com/showthread...hreadid=546812 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Graps in macros
if it is on a separate chart sheet
Charts(1).Name = "MyName" if it is on a worksheet activesheet.ChartObjects(1).Charts(1).Name = "MyName" Something along those lines. -- Regards, Tom Ogilvy "jormonal" wrote: I'm trying to create a new graph BUT later i need to make some enhancements in it. I'm trying to give the graph a NAME because I need to refere it in another macro, but I can't give a graph a name inn order to later select it. VB uses "GRAPH nn" as a standard name of graphs... Any suggestions??? -- jormonal ------------------------------------------------------------------------ jormonal's Profile: http://www.excelforum.com/member.php...o&userid=34949 View this thread: http://www.excelforum.com/showthread...hreadid=546812 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
| Macros inside macros, and pasting into macro code. | Excel Programming | |||
| convert lotus 123w macros to excel macros | Excel Programming | |||
| Macro Size Limit / open macros with macros? | Excel Programming | |||
| Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
Linear Mode
