Excel 2019 show properties and Form in Design mode

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,954
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Have they disabled this ? The properties window now replaces the Form.
Can you never see both at once ?
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sure.. the properties window and Form swap with View-Properties Window and Forms View Object.
In Excel 2010 properties are under the Project Explorer. You can see what control you're looking at (at the same time).
 

Attachments

  • excel1.jpg
    excel1.jpg
    48 KB · Views: 20
Upvote 0
When the properties window is visible, what happens if you drag the title bar of the properties window on top of the title bar of the project explorer window ?
If it works you may then need to reverse the 2 windows by dragging the project explorer title bar to the properties title bar.


For a visual:
 
Upvote 0
I get the idea, but have made it worse! The left hand pane has gone completely and the remaining areas are full width.
The Project, Immediate and Watch windows I can drag to a small movable window, andrestore back
But the Properties and Form Design (depending which is showing) don't seem to have a title bar at the moment and don't move.
But I'd need to get the LH pane back to have another try.
 
Upvote 0
Can you have a look under:
Under Tools > Options > Docking
and see if you have the Project and Properties windows checked.
If they are turn them off and hit OK
Then go back in and turn them back on again.
 
Upvote 0
Solution
Ahhh brilliant. I had the top 3 only ticked. So ticked them all and the LH pane restored... then I could drag everything and it's all back
now like it should be. Whew! It was sending me bonkers....
Thank you :)
 
Upvote 0
Glad to see you have it working OK now.:cool:
When the properties window is visible, what happens if you drag the title bar of the properties window on top of the title bar of the project explorer window ?
If it works you may then need to reverse the 2 windows by dragging the project explorer t
 
Upvote 0
Ahhh brilliant. I had the top 3 only ticked. So ticked them all and the LH pane restored... then I could drag everything and it's all back
now like it should be. Whew! It was sending me bonkers....
Thank you :)
The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.
 
Upvote 0

Forum statistics

Threads
1,221,653
Messages
6,161,067
Members
451,684
Latest member
smllchng5

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