Personal Macro Workbook
Personal Macro Workbook
It would save me much time if my VBA macros were available to all of my Zoho Sheet workbooks. I could not find a way to create an equivalent to Excel's Personal Macro Workbook. Having the capability to establish a reference in the VBA Editor to another workbook -- making that workbook's macros available -- would be an ideal solution to the problem.
Separately, many hours were lost yesterday when I tried to use VBA to take cell values [X = range().value] and use them in an equation [Y = 2* X]. (X and Y were dim Single). The VBA equation would work if the cell contained a number [4], but not if the cell contained an equation [=2+2]. I later deduced that currency-formatted cells with equations are seen in VBA as strings beginning with a "$."
I had to write a VBA function to strip the "$" from these numeric entries to use them mathematically. This IMHO should not have been necessary.
Oh, yeah. One more thing. I know the Freeze Pane capability is new, but some instructions on Freezing row and columns simultaneously would be helpful.