Forum Discussion
Excel formula combinations
- Oct 11, 2020
Don't worry, I know that you are dealing with Macros very first time. But once you get the idea about how they work and what they can do for you, you will start learning them. 🙂
Please watch this short demo video (with no audio) to know how this works.
Let me know if doing the same on your end doesn't work for you.
Hi, Yes i have disabled protected view and enabled macros but if i click on a product description cell the price do not change. Sorry for being a nuisance to you i have used Visual Studio 6 extensively developed large management systems for two companies but never used VBA for Excel before so i do not know how the two, Excel and VBA, fits together and what to do.
Thank You so much!!!!
Regards
Don't worry, I know that you are dealing with Macros very first time. But once you get the idea about how they work and what they can do for you, you will start learning them. 🙂
Please watch this short demo video (with no audio) to know how this works.
Let me know if doing the same on your end doesn't work for you.
- Subodh_Tiwari_sktneerOct 12, 2020Silver Contributor
Sorry, I couldn't understand what you wanted to describe.
If this is not related to your original question and the solution I provided, you can always open a New Question so that maybe someone else would be able to understand it and help you with your issue.
- kobus1305Oct 12, 2020Brass Contributor
Hi, There is one procedure that i can not figure out. I want to open, or if it is already open display it, from the one workbook "Quotation Program.xlsx", which works using HYPERLINK("[Quotation Unit Prices.xlsm]"). But say all the info for the quote on "Quotation Program.xlsx" has been completed i want to open, or display if it is already open, the "Quotation Prices.xlsm" workbook. When "Quotation Prices.xlsm" displays it must also be on May worksheet and not the last worksheet that has been worked on. How and is it possible to do that??
Regards
Thank You