ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   No controls for Maxmiza, minimiza & restore ? (https://www.excelbanter.com/excel-discussion-misc-queries/181876-no-controls-maxmiza-minimiza-restore.html)

Irfan Khan[_2_]

No controls for Maxmiza, minimiza & restore ?
 
Hi All,

in one of my workbooks I did something in VB editor after that particular
workbook is not geeting minimized maximized or restored. one problem is i
made one worksheet -xlVeryHidden now it not getting visible and property box
is showing error that class cannot be chaged. Please Help.

Regards


Jan Karel Pieterse

No controls for Maxmiza, minimiza & restore ?
 
Hi Irfan,

in one of my workbooks I did something in VB editor after that particular
workbook is not geeting minimized maximized or restored. one problem is i
made one worksheet -xlVeryHidden now it not getting visible and property box
is showing error that class cannot be chaged. Please Help.


Unprotect the workbook.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com


Irfan Khan[_2_]

No controls for Maxmiza, minimiza & restore ?
 
Hi,

I did that also but not working...

"Jan Karel Pieterse" wrote:

Hi Irfan,

in one of my workbooks I did something in VB editor after that particular
workbook is not geeting minimized maximized or restored. one problem is i
made one worksheet -xlVeryHidden now it not getting visible and property box
is showing error that class cannot be chaged. Please Help.


Unprotect the workbook.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com




All times are GMT +1. The time now is 01:33 PM.

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