Hi,
I have a multiple sheets and each of them are linked with each other.However,I want to removing any link that is associated with "Main" worksheet and converting the data into value of other worksheet which is linked with "Main" worksheet.The interlink with other worksheets is to be left intact i.e no change should be there.
A sample file with few worksheet is enclosed for your kind reference.
Hoping a positive response in this regard.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanx for the response.There is an error prompting at 4th row while testing.Also,kindly note that the wherever links in whatever cell reference are there that r linked with 'Main' sheet be converted into values.
I think it had worked but when adding one more sheet i.e "Sheet3",the above code does not work.
Kindly note that again that wherever links in whatever cell reference are there that r linked with 'Main' sheet be converted into values.
Hope I could able to make it understand.
Hoping a positive response to this query.
Sample workbook is enclosed for your kind reference.
Still eagerly waiting for the response.
Apologies My Mistake.
Please Login or Register to view this content.
Last edited by mehmetcik; 11-16-2017 at 01:05 PM.
Dear Sir,
Thanx for your kind reply.Can you plz upload workbook with code as enclosed in Post #4 after testing your code.I have tested but seems to be not working.
Any help in this regard will be further appreciated.
Ok
I see the issue.
Try this Version.
Please Login or Register to view this content.
Perhaps this has worked out.Thanx for your kind reply.
I would like to have one more favour if you do not mind it.
Everything is same as above,now instead of converting value (which was awesome as per your Post #8),can all the formula which is linked with "Main" worksheet be absolutely be hidden,so that no one can see the formula/link that is linked with "Main" sheet.
Hoping your further kind response.
Eagerly waiting for your kind response.
Ahh, sorry.
We usually do something differrent for that scenario.
This Macro is in the Workbook Macro module of the attachment.Please Login or Register to view this content.
It makes it impossible to select any cell with a link to main.
Thankx for your kind reply once again.
I would like to express one more thing is that when I use your code as mentioned in Post #8 in my original workbook changing the worksheet name "Main" to another name "tb",the code fails to works.Can you let me know why this happen ? Is there any hidden restriction imposed ? Kindly let me know.I can share my original workbook but not publicly here.My email id - [email protected].Pls revert in email,I will share to you privately.
Hoping your kind co-operation in this regard.
Last edited by paradise2sr; 11-22-2017 at 08:21 AM.
We are searching for the name "Main" in the macro.
If you change that name to something else then the macro fails.
There is a way around this.
If your sheet main is sheet1 of your workbook then we can read the sheet name for sheet1 and then run our macro.
I will show you how.
But first.
Try this:-
Please Login or Register to view this content.
Ok I have tested this and it seems to work.
Please Login or Register to view this content.
Last edited by mehmetcik; 11-23-2017 at 05:20 PM.
Ok.Pls find enclosed in attachment my file.The code still does not seems to work.I have mentioned your code as stated.Only the filename is changed but still could not get into.I have deleted all other sheet for simplicity.
Plz revert the same file,if succeeds.If not,kindly close this thread from your end.
And thankx for your consistent support.
Last edited by paradise2sr; 11-23-2017 at 12:16 PM.
This code works for your example:
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mehmetcik; 11-23-2017 at 05:19 PM.
Thanx.Finally you post #15 worked out in my attachment post #14.
Lastly,
Kindly refer post# 9 that how would you revise your code.in below case
"I would like to have one more favour if you do not mind it.
Everything is same as above,now instead of converting value (which was awesome as per your Post #8),can all the formula which is linked with "tb" worksheet be absolutely be hidden,so that no one can see the formula/link that is linked with "tb" sheet..Worksheet "Main" is replaced by"tb" as per mine post #14.
Hoping your further kind response. "
Momentarily I am marking this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks