Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to copy the sheet in same application on button click. Is there any way to copy the sheet.
Thanks in advance!!!
Hi Monika,
You need to use Macro for this, but why u need this!!! You can right click on the sheet and can make a copy rite.
i dont think its possible by button click...
do you have the macro to copy sheet.
I believe this won't be possible per macro like the gui-functionality with right click and copy sheet. I think you will need to create a new sheet and all objects new and transfered all properties from the old sheet/objects to the newer one. It will need a lot of effort ... maybe you could make normal copies from the sheets and hide them until the user pressed the button ...
- Marcus