Why are my Properties Grayed out?

H

Hercules1946

Well-known Member
Joined
Oct 6, 2007
Messages
545
Hello
Whilst I was using the Visual Basic Editor, I noticed that if I saved the current workbook to disk, and then displayed the VB Editor with the Project and Property windows open, then any values displayed in the righthand section of the Properties window are grayed out. This applies to any selected item in the properties window.

The values can be reactivated by selecting another available window, and then returning to the VBE. This seems rather curious behaviour that I haven't noticed before. Could this be due to some setting that Ive altered by mistake?

Any Help would be appreciated

Thank you
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You must log in or register to reply here.

Similar threads

E
  • Question
Can anyone help me get my VBA code working? I have spent tons of time but can't quite fix it.
Replies
3
Views
2K
profray
P
M
  • Question
Cell notes following my cell selection
Replies
1
Views
1K
Mrock1
M
J
  • Question
Data Properties Tab Grayed Out on unprotected and non-shared workbook
Replies
0
Views
619
Jonathan King
J
R
  • Question
Two severe and company-breaking Excel crashes (VBE7.dll and Cannot Find Project or Library)
Replies
1
Views
3K
RoryA
RoryA
C
  • Question
VB error "Object doesn't support this property or method"
2
Replies
10
Views
2K
mikerickson
mikerickson

Forum statistics

Threads
1,214,628
Messages
6,120,618
Members
448,973
Latest member
ChristineC

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top