Dialog Sheets

[tsweeney]

I have an excel sheet that was originally made in 97-2003 and has since been updated into Excel 2010. This worksheet made use of Dialog Sheets to perform the same function that a Userform would now.

But apparently, the dialog sheets are now gone for editing purposes. The macro that activates them is still working and doing what it should and I can see the sheet when I run the macro. However, I can't get into the sheet to change anything.

 

[GlennUK]

Have you made sure that the dialog sheet is not hidden?

 

[tsweeney]

Yeah. I figured it out, sorry for not following up

The sheets were hidden, but I could originally not unhide them because the workbook structure was protected. As soon as I called and got the password to unlock it, the sheets were there and I completed what I needed to do. The workbook was being used by people who have less than stellar work ethics that will find a way to break it if they can so they don't have to work, so the boss had to lock the thing up tight, but neglected to tell me that he did so.

 

[GlennUK]

That's great. Glad you got what you needed.