I know this is a long shot, but is there any way to have the security warning that shows when someone else first opens my Macro-enabled workbook, show up in the middle of the page?
Or even a message that pops up that tells the user that they have to enable content for the worksheet to work properly?
I'm trying to make my workbook as dumb-dumb proof as possible. The small Security Warning that shows at the top of the program can easily be missed.
I was thinking i could maybe add a WordArt Shape over the whole sheet, telling them the have to click the 'enable content' button, then with my first line of code, remove the shape, but was hoping there is a better solution.
thanks
Or even a message that pops up that tells the user that they have to enable content for the worksheet to work properly?
I'm trying to make my workbook as dumb-dumb proof as possible. The small Security Warning that shows at the top of the program can easily be missed.
I was thinking i could maybe add a WordArt Shape over the whole sheet, telling them the have to click the 'enable content' button, then with my first line of code, remove the shape, but was hoping there is a better solution.
thanks