Many people find the process to conceal shape in spreadsheet quite challenging, particularly if they don't regularly work with paperwork. Nonetheless, nowadays, you no longer have to suffer through long tutorials or wait hours for the editing app to install. DocHub allows you to change forms on their web browser without setting up new programs. What's more, our robust service offers a complete set of tools for comprehensive document management, unlike numerous other online solutions. That’s right. You no longer have to export and import your templates so often - you can do it all in one go!
No matter what type of document you need to adjust, the process is straightforward. Take advantage of our professional online solution with DocHub!
The MrExcel podcast is sponsored by Easy-XL. Learn Excel from MrExcel podcast, episode 1899. Resize Rectangle Based on Formula Cell Results. Hey, welcome back to the MrExcel netcast. Todayamp;#39;s question sent in by YouTube. Iamp;#39;ve created a shapes rectangle in Excel and can edit the size, you know, height and width, but I would like this to automatically resize, based on these formula results. Is that possible? All right, yes, itamp;#39;s possible, but you have to use a VBA macro. So in order to use VBA macro, couple of things. Alt, T, M, S, make sure that you are not set to the highest security there, otherwise you canamp;#39;t use macros. Also, if your file is stored as xlsx, which is very, very common, you have to do File, Save As and save as xlsm or xlsb. Xlsx is not allowed to have macros, all right. First thing we have to do, is figure out the name of this, looks like itamp;#39;s Rectangle 1, but you know what, Iamp;#39;m lazy, Iamp;#39;m going to record a macro, i