PinelopiNstrd
New Member
Hello everyone! 
I am not a pro in VBA but I would really like to become one!
Until now I only used it as a way to speed up some independent processes that would take long to be done by a person.
But now, I need to create a report that would seem like an application to be more attractive and have a specific template.But is in not as easy.
Could you please provide some help?
Before reading the case, let me highlight that I am not able to use active x controls or APIs due to limitations.
So, I am always talking about simple user form controls.
The idea of the case is to have pairs of sheets (one for the info without any formatting and one for the template "to look pretty"). And make invisible all excel characteristics so that the report would only have visible the spreadsheet (I know I have to apply that code when opening the workbook and reset it before closing, but have not done it yet to check the progress of code easier)
So I tried to create all subs in module code and write them in a way to be used by all sheets of the file, if providing the sheet name (and the info sheet in some subs) with minimum adaptations in sheets' code.
So, I am facing some difficulties with scrollbars1. They do update the tables in ViewSheets when clicking the arrows or choose the LargeChange, but if I try to use the slide bar, the table will only be updated after I release the mouse. I tried to use a timer to check changes in the scrollbar value cells, or window updates but both solutions did not work.Plus that sometimes it seems like the slide bars are "untouchable". I am not able to pick them and move them up or down.
2. I wanted for some specific shapes to roll along with the window scroll, so that user could always see them in a specific distance from first visible cell. It also works only after I select a new cell on the sheet. I tried to make it work with timer or first visible cell check, but in the end I did not figure it out.
3. Last but not least, since I have faced loss of a version due to some loop that I accidentally created, I wanted to add a safe code while opening the workbook, to be able to open it without the code running and fix whatever I need. I came across a solution, but I think it needs API or something that I am not able to do and for the time being it creates an error when opening. Are there any other ways to prevent the above scenario and protect the code?
Thank you all for your replies and support!
I know my "project" is not very interested or difficult for VBA experts, but I just started using VBA and there are to many things to catch up on with.
PS
The view is different in my labor excell than my personal, cannot understant why!
Pinelopi
I am not a pro in VBA but I would really like to become one!
Until now I only used it as a way to speed up some independent processes that would take long to be done by a person.
But now, I need to create a report that would seem like an application to be more attractive and have a specific template.But is in not as easy.
Could you please provide some help?
Before reading the case, let me highlight that I am not able to use active x controls or APIs due to limitations.
So, I am always talking about simple user form controls.
The idea of the case is to have pairs of sheets (one for the info without any formatting and one for the template "to look pretty"). And make invisible all excel characteristics so that the report would only have visible the spreadsheet (I know I have to apply that code when opening the workbook and reset it before closing, but have not done it yet to check the progress of code easier)
So I tried to create all subs in module code and write them in a way to be used by all sheets of the file, if providing the sheet name (and the info sheet in some subs) with minimum adaptations in sheets' code.
So, I am facing some difficulties with scrollbars1. They do update the tables in ViewSheets when clicking the arrows or choose the LargeChange, but if I try to use the slide bar, the table will only be updated after I release the mouse. I tried to use a timer to check changes in the scrollbar value cells, or window updates but both solutions did not work.Plus that sometimes it seems like the slide bars are "untouchable". I am not able to pick them and move them up or down.
2. I wanted for some specific shapes to roll along with the window scroll, so that user could always see them in a specific distance from first visible cell. It also works only after I select a new cell on the sheet. I tried to make it work with timer or first visible cell check, but in the end I did not figure it out.
3. Last but not least, since I have faced loss of a version due to some loop that I accidentally created, I wanted to add a safe code while opening the workbook, to be able to open it without the code running and fix whatever I need. I came across a solution, but I think it needs API or something that I am not able to do and for the time being it creates an error when opening. Are there any other ways to prevent the above scenario and protect the code?
Thank you all for your replies and support!
I know my "project" is not very interested or difficult for VBA experts, but I just started using VBA and there are to many things to catch up on with.
PS
The view is different in my labor excell than my personal, cannot understant why!
Pinelopi
