run code when maximize or minimize the excel window

frsm

frsm

Active Member
Joined
Jun 19, 2006
Messages
258
hello all

i want to run a code if the activesheet is minimized oe if it is maximized

is it possible?

thanks
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Sort by date Sort by votes
sorry ! no answers ! may be i dn't explain my question well .

i want to run a code (msgbox "sheet has been minimized ") if i minize the active sheet
 
Upvote 0
There's no event that I know of that is triggered when the workbook/sheet/window is resized.

So I think your out of luck, sorry.:)
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Locked
  • Question
excel hide minimize, expand and close
Replies
3
Views
205
Fluff
Fluff
M
  • Question
Excel ribbons are greyed out MacOS
Replies
0
Views
174
memadhava
M
S
  • Solved
This Workbook event code for Workbook_WindowResize
2 3
Replies
29
Views
1K
sspatriots
S
Wil Moosa
  • Solved
WindowState = xlMinimized does not show name of workbook
Replies
3
Views
325
Wil Moosa
Wil Moosa
P
  • Question
Hide everything other than the top MINIMIZE-EXPAND-CLOSE
Replies
2
Views
230
Jaafar Tribak
Jaafar Tribak

Forum statistics

Threads
1,214,793
Messages
6,121,614
Members
449,039
Latest member
Mbone Mathonsi

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