I have a excel sheet with image inserted.that image multiplied and going down n number of times.So i want to to stop srolling the worksheet by users till some end like A24 to V24.SImply user should not be able to access/View the sheet beyond the mentioned limit.Any options in the excel workbook?
You can set the scroll area,
In design mode, click the sheet properties and you can select the scroll area there.
10-7-2015 1-09-07 AM.jpg
Unfortunately, the scroll area will not save when you exit the workbook, so you will have to set the scroll area when you open the workbook, with VBA.
This goes into the Workbook Module.
Please Login or Register to view this content.
No Words dave.Awesome.Also i have one more Q here.I have setup a macro with buttons which holds small images.That doesnt matter.When i click the button it trigger userform which i built in (Here before that the general popup box will open with OK button).When i click OK/CLose button it is triggering the Userform to open.But i dont want to trigger userform when select close button and it should open when i click OK alone.
I don't know, I can't see the code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks