paste value all sheets then delete several sheets

[hoomanamooh]

Hi dear professors
i need an emergency help again please
you are just like angles in my work life
in sample file(attachede) i need a vb code that paste special all data in all sheets on them with out any error or question from user and just be remain data in file without formula but with links.( links remain)
then delete several sheets ( coding and centers and Targets )
then save file with excel name in .xlsb(binary mode) like save such as: sample.xlsb
thanks thanks thanks alot
you are like hero in my life

 

[vletm]

hoomanamooh​

Do ... in sample file(attachede) ... come later?

 

[hoomanamooh]

hoomanamooh​

Do ... in sample file(attachede) ... come later?

hi, file is 5MB and cant upload it. i am tying to compress and attach soon

 

[hoomanamooh]

i can not even attach 2 MB file ???

 

[vletm]

Max 1MB
Create a sample Excel-file which has needed sheets and sample datas.
You seems to send a ... rar-file.
Maybe someone else will open and check it - good luck.

 

[hoomanamooh]

hoomanamooh​

Do ... in sample file(attachede) ... come later?

we can just attach files under 1mb?
i deleted several important sheets that change file size from 5MB to 900KB

 

[hoomanamooh]

here you are
please help me

 

[vletm]

hoomanamooh​

You should able to explain other ways next sentence:
paste special all data in all sheets on them with out any error or question from user and just be remain data in file without formula but with links.
What should do?
... some kind of expected result would help a lot too.

 

[hoomanamooh]

excuse me
my english is not good
i live in iran
with this macro i need that copy every sheets and paste value all data on its self(all sheets) without any question from user
with this vba i need to replace all formulas with data
there are several links in this workbook and i need to dose not delete these links
very simple explain: i need to remove all formulas in entire of workbook(all worksheets) and then delete several sheets that i named at first and then save workbook in binary format.
thanks alot

 

[vletm]

hoomanamooh​

One sample ...
usage: Click 'Top Right' -logo

 

[hoomanamooh]

hoomanamooh​

One sample ...
usage: Click 'Top Right' -logo

thank you
but is there any way that make this like 1 vb code with a button in page (Menu) that when user click a shape that code runs?
users dont know vb and can not use, i should put a shape in sheet (menu) for run this vb code
thanks so much

 

[hoomanamooh]

hoomanamooh​

One sample ...
usage: Click 'Top Right

thanks a lot
you are a really excel proffesor
thank you

 

[vletm]

hoomanamooh​

Do those two hidden sheets need to be there?