Show userform in activesheet

[Karthik Thandapani]

Hi,

I have 2 userforms built in the attached workbook. Requirement is to show those userforms in the activepage.
What I am trying to achieve is: To create a newsletter using excel workbook hiding ribbons, grids, taskbar, sheets from the user. So I can provide an option using userforms to select desired column.
Userform1 would actually float on top of the page and Userform2 at the extreme left.

Alternatively, when I experimented with excel default option, freeze pans as it shows a line on top. Is there a way to remove that but just freeze the top row and left so it scrolls along with user scroll.

Please see the attached file.

Thanks in advance.

 

[prasaddn]

Hi Karthik,

You need to set the form's showmodal's property to false.

And set the start up position to 0 - manual and set the top and left to whichever position on screen you need.

See the attached file. Run the sub test in sheet1 to check if it is same what you wanted.

Regards,
Prasad DN
PS: Not sure how to change the color of the freeze row/column line.

 

[prasaddn]

some issue uploading the file. you can set the properties as i suggested and code the lines to userform1.show in any events like workbook.open etc

 

[Deepak]

I think you are looking for something like this..

 

[Speedy]

Hi,

Using the API you can cut out the form ...
To use one userform

 

[prasaddn]

Very nice trick Speed!!

 

[Karthik Thandapani]

thanks!