Working With Excel's XML-Based File Formats

Excel 2007

Mangesh123 — Wed, 22 Aug 2007 09:21:51 GMT

I would like to customize Excel 2007,

Please tell me how to remove office button appearing on top left corner of Excel 2007.

With regards

-Mangesh

re: Working With Excel's XML-Based File Formats

David Gainer — Wed, 22 Aug 2007 09:25:48 GMT

Hi Mangesh - there is no way to remove the button.

re: Working With Excel's XML-Based File Formats

Mangesh — Wed, 22 Aug 2007 11:44:58 GMT

Thanks David.

So can we disable drop down Pop-up from office button appearing in top left corner of Excel 2007 also what is control id and control type of Excel options button and Exit excel button.

With regards

-Mangesh

re: Working With Excel's XML-Based File Formats

David Gainer — Wed, 22 Aug 2007 19:23:38 GMT

Hi again

There are a bunch of materials on Ribbon extensibility here - hopefully that answers your questions.

http://msdn2.microsoft.com/en-us/library/aa942866(VS.80).aspx

Microsoft Excel blog posts

Walter Stiers - Academic Relations Team (BeLux) — Wed, 22 Aug 2007 21:55:19 GMT

Microsoft Excel blog has 2 recent post I would like to refer to: Working With Excel's XML-Based File

Microsoft Excel blog posts

Noticias externas — Wed, 22 Aug 2007 22:57:20 GMT

Microsoft Excel blog has 2 recent post I would like to refer to: Working With Excel's XML-Based File

re: Working With Excel's XML-Based File Formats

Steve Dillinger — Thu, 23 Aug 2007 21:41:42 GMT

All these new features are great- but there are still MANY bugs working with VBA. I cannot make a remotely complex sheet w/ data connections and forms without excel 'losing' the form:

Run-Time error -2147352573 (800020003)

Could not find the specified object.

THATS IT! My sheet is now toast forever. I have to rip out that object (not easy because it can't be 'found' anymore) and reinsert it. Easily several days worth of work to redo. This has happens **frequently**. I can send an example sheet if anyone cares. - sdillinger@cornerstonetg dot com

re: Working With Excel's XML-Based File Formats

Jessica — Thu, 23 Aug 2007 23:07:00 GMT

i need to know how to underline the current row that i am editing. it will just highlight or underline the specific row until i am finished editing that row.

Can you tell me how to do that??

re: Working With Excel's XML-Based File Formats

Jessica — Thu, 23 Aug 2007 23:07:06 GMT

i need to know how to underline the current row that i am editing. it will just highlight or underline the specific row until i am finished editing that row.

Can you tell me how to do that??

re: Working With Excel's XML-Based File Formats

Harlan Grove — Fri, 24 Aug 2007 21:05:17 GMT

Yes you can remove the Office button, but only as part of removing the entire UI. Not necessarily a bad idea.

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"

XLM to the rescue!!!