View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
johan johan is offline
external usenet poster
 
Posts: 34
Default How to enable "Links" when copy a worksheet (with buttons on it)t

Thanks for the respons,

I'd tried the solution, but it copies the file without the buttons on
it and still with "links" (when looking by menuoption "edit - links".

I want to try another solution as describe below. Can somebody please
help me out.

I need a macro that made a copy of the actual sheet into a new
workbook (create a copy - new book).
Then the macro has to save directly the file into the directory C:/
Apps with the name "Template-date-time.xls" (date and time as actual).
After that the action should be taken: menuaction "Edit - Links -
Change Source" and then change the source to the before saved
filename.

Then the file has, after copy the sheet with the buttons no "links"
anymore to the original file.

Possible ?? or another solution ?

regards,
Johan