design

Hi Everyone, I hope I can find an answer in this forum :) I'm working on formatting 20 finance tables in Excel for Mac and want to create a system for future use. The goal is to make it easy for our finance team to format tables consistently. So I've formatted a table with various styles...

I have the following spreadsheet with about 2000 rows, ABCDEFGHIJKLMNO1Ref No(s)TitleEff DateATAComments2TEST 1B737 ADVERTISING PLACARD INSTALLATION25Referenced By: TEST3ParagraphMethod Of ComplianceRLifeLast ComplE/D O/RideLimit/ IntervalF/ LNext DueRemain4Initial Issue...

I am trying to disable the design view so user cannot make any changes. Greatly appreciate if you can help or what other option I can do to protect my database from being modified. Thank you!

I am trying to see my query in Design View, but its only coming up in SQL (I am clicking Design View not SQL View). I'm not that good at SQL so I need to see it in Design view. Anyone know how to fix this? Thanks

Hi I have several formulas in different cells. I wanted to show the formula not the value so I thought of adding ' to = I went to Home-->Find and replace--> = with '= It did work Then I wanted to do the reverse and replacing '= with = but I got error message saying could not find '= Is that...

Hi I want to understand Developer-->Design mode and what is used for. I read this post https://www.mrexcel.com/forum/excel-questions/32669-design-mode-vba.html and Parry said: ""If you select the Control Toolbox to draw a control etc, you will notice that design mode automatically comes on.""...

This seems quite simple to me but i'm a bit rusty and i just cant figure it out. I have a table full of orders (which gets added to) with order number/garment type/design type/fabric colour/printing colour/size eg: 10000001/tshirt/frog/green/black/XL i want to order them, starting with the...

Hello there, i'd like to use the custom design i made for my table in all excel files? Illustrative screenshot from PERSONAL.XLSB:

I need to design a spreadsheet, almost a monthly planner to yearly to show Key meetings per month by month /date Attendees (same 4 people) Pre work Post work What’s the best way to design this? I’ve thought of various designs but they don’t include all info I need. Any help on...

Apologies for my less descriptive title. There is more nuance to the situation, but I couldn't fit it in a short title. Background: The situation I am dealing with is this. We have a master takeoffs spreadsheet that we've created with about 8 different tabs in it. For the longest time there...

I am in the design phase and looking to get some ideas on the best way to design my spreadsheet. We have a small private org that makes purchases and hold fundraisers. Some items we buy in Japanese yen and some we buy in US Dollars. We also receive Japanese Yen and US dollars. What is the best...

Hey guys, I'm new to this forum. I tried to look for related posts first but to no avail. I created a userform with tons of (working) controls, uploaded to cloud and downloaded it on other conputers. The file's main usage will be on the userform. The issue is, on most computers, the userform...

Hi all, I was wondering if this would be possible to do, and if so how to apply the correct steps in the power query to achieve it? The Query pulls a certain sheet from a workbook, lets call it sheet1, loads the contents of that worksheet, and then in column 5, IF there is the words "Lathe...

Hello All, I've just released a very large project for my office and my first tester is the only person I can find in 6 different people that can't type or even select the only combobox in the workbook. The office is mixed running 2013 and 2016, I've found people can use this box regardless...

Is there a way in design mode to have the properties dialog box caption set up for taking its value you from a sheet cell. Making the caption varible in design as well.

<tbody> HEIGHT 2000 WIDTH 2100 TOTAL SIZE 4100 DESIGN 1 Out of Range </tbody> Hi I would like a function that will detect if a value is outside the design parameters. Example: DESIGN 1 is only compatible if the total size is between 1000 & 4000 inclusive. How can I write a...

- On the Insert tab, in the Text group, click Header & Footer. - Under Header, click either the left, center, or right header selection box. - On the Design tab of the Header & Footer Tools, in the Header & Footer elements group, click Picture and then find the picture that you want to insert...

Hi Guys! Please help me with my problem about Switchboard. I created my Switchboard with the usual process of creating a simple Switchboard. I used the Default Main Switchboard and i think there is no problem with that if I use that or by creating a new one. Then I input the items on the...

I have place a command button on a worksheet to run a macro, but when I click the button it says that it cannot find the macro. I wanted to delete everything and start again, but when I enter Design Mode on the Control Toolbar I cannot select the button, move it, or anything. Any advice would...

I just discovered what I consider a major flaw in the design of the Union (comma) operator. As illustrated in the workbook here: https://www.dropbox.com/sh/v0799qr2uex4imf/AAAWi4Jhq4-vfCmuQTn4qo4Za?dl=0 The Sum function, when applied to a union of overlapping ranges, will sum the values in the...