ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent Reviewing CommandBar from showing? (https://www.excelbanter.com/excel-programming/384292-prevent-reviewing-commandbar-showing.html)

Ed

Prevent Reviewing CommandBar from showing?
 
Is there any way I can globally prevent the Reviewing CommandBar from
popping open? I've done it in Word with a macro in my Normal template,
which underlies all my docs. But the same thing in my Excel Personal
doesn't work the same (because XL doesn't work like Word - I know that, but
thought it was worth a try!).

Is there any way to force a CommandBars("Reviewing").Visible = False on
every workbook that opens? If for some reason I really need it, I can write
a Visible = True to get it.

Ed



Bob Phillips

Prevent Reviewing CommandBar from showing?
 
See http://www.xldynamic.com/source/xld.xlFAQ0009.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ed" wrote in message
...
Is there any way I can globally prevent the Reviewing CommandBar from
popping open? I've done it in Word with a macro in my Normal template,
which underlies all my docs. But the same thing in my Excel Personal
doesn't work the same (because XL doesn't work like Word - I know that,
but thought it was worth a try!).

Is there any way to force a CommandBars("Reviewing").Visible = False on
every workbook that opens? If for some reason I really need it, I can
write a Visible = True to get it.

Ed




Ed

Prevent Reviewing CommandBar from showing?
 
Thanks Bob!
Ed

"Bob Phillips" wrote in message
...
See http://www.xldynamic.com/source/xld.xlFAQ0009.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Ed" wrote in message
...
Is there any way I can globally prevent the Reviewing CommandBar from
popping open? I've done it in Word with a macro in my Normal template,
which underlies all my docs. But the same thing in my Excel Personal
doesn't work the same (because XL doesn't work like Word - I know that,
but thought it was worth a try!).

Is there any way to force a CommandBars("Reviewing").Visible = False on
every workbook that opens? If for some reason I really need it, I can
write a Visible = True to get it.

Ed







All times are GMT +1. The time now is 07:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com