Forum Discussion
Excel
Mar 12, 2021Iron Contributor
Question related to hidden sheet in excel VBA
Hello Everyone, Suppose i have sheet. And i hide the ZAN sheet Like - When i run the code, then i select ZAN sheet in dropdown Like - Then it give me error. like - ...
Excel
Apr 24, 2021Iron Contributor
Hello Sir,
I have a two questions -
>> 1st question - When i click in CANCEL two times, then it shows error message.
Like -
when i click in DEBUG button, then it will yellow line highlighted -
so ,what will i write in code, when i click in CANCEL so userform remove?
2nd question - How to add below code in UserForm_Initialize -
Please help...???
Here is the attached file.
HansVogelaar
Apr 24, 2021MVP
See the attached version.
- ExcelApr 24, 2021Iron Contributor
It works! Thank you so much sir😊😊