ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Issue with "ToggleFormsDesign" a method of Excel workbook (https://www.excelbanter.com/excel-worksheet-functions/137281-issue-toggleformsdesign-method-excel-workbook.html)

UK

Issue with "ToggleFormsDesign" a method of Excel workbook
 
Hi all,

I have written a VB code where I added Excel 12.0 object library to work
with Excel. I wrote a code to Toggle Design Mode, using _workbook method
"ToggleFormsDesign". Now, when I run this VB code with Office XP i.e Excel
2002, it shows a error message "Object does not support property or method".
Is there any other method to toggle the design mode in Excel 2002.

Any solution is appreciated.

Thank you,


All times are GMT +1. The time now is 09:13 AM.

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