Can i see the excel coding with out macro?

Hi,

Can i see the excel coding with out macro? I have one design chart in my excel sheet. The sheet has no macros.i want to see that coding. Because I want to create that sheet dynamically. Can i see the coding?. I want to see that coding. Anyother way to find the coding?


Pls help me.
Ram

Right click on the sheet tab and select View Code to see all the code in the
workbook.

--
Ian
--
"ramkumar_cpt" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> Can i see the excel coding with out macro? I have one design chart
> in my excel sheet. The sheet has no macros.i want to see that coding.
> Because I want to create that sheet dynamically. Can i see the coding?.
> I want to see that coding. Anyother way to find the coding?
>
>
> Pls help me.
> Ram
>
>
> --
> ramkumar_cpt
> ------------------------------------------------------------------------
> ramkumar_cpt's Profile:
> http://www.excelforum.com/member.php...o&userid=28673
> View this thread: http://www.excelforum.com/showthread...hreadid=486756
>

What coding do you think exists that is not a macro?

If I get what you want to do, I would suggest that you turn on the macro
recorder, create that chart anew, and modify the recorded macro to your
specific needs.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ramkumar_cpt" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> Can i see the excel coding with out macro? I have one design chart
> in my excel sheet. The sheet has no macros.i want to see that coding.
> Because I want to create that sheet dynamically. Can i see the coding?.
> I want to see that coding. Anyother way to find the coding?
>
>
> Pls help me.
> Ram
>
>
> --
> ramkumar_cpt
> ------------------------------------------------------------------------
> ramkumar_cpt's Profile:
http://www.excelforum.com/member.php...o&userid=28673
> View this thread: http://www.excelforum.com/showthread...hreadid=486756
>

If you mean see all the equations in the cells, then just touch CNTRL `

(CNTRL-TILDA) toggles the equation view
--
Gary's Student


"Bob Phillips" wrote:

> What coding do you think exists that is not a macro?
>
> If I get what you want to do, I would suggest that you turn on the macro
> recorder, create that chart anew, and modify the recorded macro to your
> specific needs.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "ramkumar_cpt" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > Hi,
> >
> > Can i see the excel coding with out macro? I have one design chart
> > in my excel sheet. The sheet has no macros.i want to see that coding.
> > Because I want to create that sheet dynamically. Can i see the coding?.
> > I want to see that coding. Anyother way to find the coding?
> >
> >
> > Pls help me.
> > Ram
> >
> >
> > --
> > ramkumar_cpt
> > ------------------------------------------------------------------------
> > ramkumar_cpt's Profile:
> http://www.excelforum.com/member.php...o&userid=28673
> > View this thread: http://www.excelforum.com/showthread...hreadid=486756
> >
>
>
>

Hi all,

Thanks for your reply. Hi ian I tried ur method. But i could not able to view the codes in your method. My sheet has no macros. Any other method to find the view code.

Hi Bob,

I tried to create the new sheet. But I could not able to create the same existing sheet. Allignment, chart size etc has differed in new sheet. if i use same existing sheet code, then i can create the similar one. so i asked.


Hi Gary,

Not only formulas i want to know the chart size, alignment, bgcolor, etc.

"ramkumar_cpt"
<[email protected]> wrote in
message news:[email protected]
>
> Hi Bob,
>
> I tried to create the new sheet. But I could not able to create
> the same existing sheet.
>
>Allignment, chart size etc has differed in
> new sheet. if i use same existing sheet code, then i can create the
> similar one. so i asked.
>

Do you mean that you cannot re-create it manually because you aren't
sure how to do it in terms of the settings?

If so, then the only other option I can think of would be to use the
object model and manually trawl through every property of a chart
object to see what they are set at.

Something like this perhaps in a standard module (assuming you have
just the one chart on the active worksheet - if not, then make it so
that it *is* the only chart on the sheet in a copy of the workbook)
and always backup your workbook before experimenting with anything:


Sub ExamineChartObject()
Set ChartToExamine = ActiveSheet.ChartObjects(1).Chart
End Sub

Now step through that macro until the 'End Sub' is highlighted, and
the use the 'Locals Window' to examine the 'ChartToExamine' object and
all of its properties / sub-properties down the object tree.

For example you might find that:

ChartToExamine.ChartTitle.Font.Bold = True


That would be quite labour intensive to check every property though!


Perhaps someone else knows a way to recursively cycle through each
property and output it as a text string in the above format in a new
worksheet?

HTH,

Alan.

--
The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:

[email protected]

This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address