Solved

Automatic Google Scripted hiding of columns and rows

Posted on 2015-01-24
2
177 Views
Last Modified: 2015-02-22
I need a way to script the automatic hiding of select columns B, J, M, O, and P (or select rows) in this online spreadsheet https://docs.google.com/spreadsheets/d/10hHAoSGpQd5nOu2YXY89_cY3Mjbw89z0qk6EFVYJuZY/edit#gid=0 for any user that the sheet has not been specifically shared to. I need to do that in such a way that they cannot be seen at all by the general public, but so that the rest of the columns can be seen by the general public.

It will require google scripting, I think.

Assistance is greatly appreciated!!
0
Comment
Question by:frugalmule
2 Comments
 
LVL 5

Accepted Solution

by:
Christopher Barnes earned 500 total points
ID: 40599276
I am not a scripting expert, but I think what you want to do is pro-grammatically (script) create a new SHEET within the spreadsheet that just contains the public data.

This public data sheet can then be published to the web.

https://support.google.com/docs/answer/37579?hl=en
0
 

Author Comment

by:frugalmule
ID: 40614752
That doesn't work because the public sheet would need to be edited by select individuals.
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Whether you’re looking to gather data for research or gather feedback on an idea, being able to build and distribute your own online survey is not only cost-effective, but allows you to reach a larger audience and receive results in real-time. Googl…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates the importance of annotations in Google Analytics and how they should be used to document changes made to a site, Google updates (Ex: Panda & Penguin), marketing campaigns, and any other events that might have contri…
This Micro Tutorial demonstrates how to create custom reports and the secrets of determine the metrics and dimensions for your data that works best with your needs.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question