Here is what i want to do.
If the value in A1=1 then set the value of B1=1.
The problem I am having is there is another macro that says if B1=1 then hide row 10. The macro I wrote will put a 1 in B1 but it does not activate the hide macro.
Here is what i want to do.
If the value in A1=1 then set the value of B1=1.
The problem I am having is there is another macro that says if B1=1 then hide row 10. The macro I wrote will put a 1 in B1 but it does not activate the hide macro.
Why not just make the code hide row 10 if A1 is 1?
Why don't you start with explaining the big picture.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
A possibility perhaps could be
In the sheet code put
and in a module put your macro to hide row 1à![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks