aj311rules
New Member
- Joined
- Oct 11, 2006
- Messages
- 4
I am using the 'Microsoft Forms 2.0 Multipage' control on a worksheet (not a userform). When I save any file and then re-open the file, I receive the error:
"This application is about to initialize ActiveX controls that might be unsafe. If you trust the source of this document, select Yes and the control will be initialized using your document setting."
I click Yes, and the control works as expected.
If I add the multipage control to a userform, save the file, and re-open the file, I do not receive the error.
The multipage control is being used on the worksheet as tabs for a report. When you click one of the tabs, it changes a value on another worksheet that will cause the charts/listboxes on the report to display different data.
I like using the multipage control over the tabstrip control, because I have had issues with when you place your cursor on a tabstrip, the tabs/buttons slightly move/expand (using the 'fmTabStyleButtons' style). This especially happens when you shrink the tabset control to show just the rows of the buttons. The MultiPage buttons do not shrink/move when you place your cursor over the button.
REQUESTED RESULT:
I would like this file to be able to be opened by other users and all they would need to do is click the 'Enable Macros' button.
Any help would be great!
"This application is about to initialize ActiveX controls that might be unsafe. If you trust the source of this document, select Yes and the control will be initialized using your document setting."
I click Yes, and the control works as expected.
If I add the multipage control to a userform, save the file, and re-open the file, I do not receive the error.
The multipage control is being used on the worksheet as tabs for a report. When you click one of the tabs, it changes a value on another worksheet that will cause the charts/listboxes on the report to display different data.
I like using the multipage control over the tabstrip control, because I have had issues with when you place your cursor on a tabstrip, the tabs/buttons slightly move/expand (using the 'fmTabStyleButtons' style). This especially happens when you shrink the tabset control to show just the rows of the buttons. The MultiPage buttons do not shrink/move when you place your cursor over the button.
REQUESTED RESULT:
I would like this file to be able to be opened by other users and all they would need to do is click the 'Enable Macros' button.
Any help would be great!