[Solved] Open Calc from a particular sheet showing a Dialog

[som]

I want to open a worksheet from a particular sheet and range. No matter where I saved it previously. I also want to show an user form at the time of opening the same. Is it possible?

[som]

No reply for a long Self help is the best help Here is a sample file created by me which will always open from a particular sheet showing a dialog. It will also show a dialog while closing

[idiminnalraj]

Dear Som,
I also want to open a worksheet from a particular sheet.As a result of my googling I reached your page and downloaded your attached spreadsheet.It is very Nice and Fantastic.I tried to work another calc file by copy paste the macro code START.But failed.I couldn't create such a file.Then I tried to attach sheets to your document.But it was protected.Can you help me?

[som]

Hi. I am presently out of my home. Please provide me some time, I shall share an unlocked worksheet at my forum within a week. Its www.askwb.com. Can you put your request there at the excel utility segment?

[som]

Hi. I have created a new topic there. Please have a look at the link below. http://www.askwb.com/viewtopic.php?f=17 ... 4398#p4398

[som]

Hi dear, I have posted the same at our forum http://www.askwb.com. Please "CLICK HERE". for entire guide lines of the same with sample worksheet.